Product Features
MUST product and services
Library Overview
Technical Support Library
Upsizing and SQL
Upsizing technical papers
.net Conversions
.net technical papers
Access Technical
Access technical papers
Quick Start Guide
upsize quickly
using schemas and security
auditing
translating SQL
commissioning
from Access to Excel reporting
Resolve SQL translation issues
Working with vw_tblParameters
Access Form to WebForm methodology
Upsizing Forum
Videos
MUST Videos
MUST+SQL Videos
MUST+WEB Videos
Highlights
Techniques
Application Administration
Access 2010 Web Databases
Articles and published papers discussing general Access development issues.
Techniques
Highlight Current Record in an Access Continuous Forms
This article shows how to create a coloured bar which highlights the current record being display in a continuous form.
Query By Form & Query By Where
This is one of the classic techniques which made Access a Killer Application, you start with
Query By Form
and then with a sprinkling of VBA code move on to programming the result using a
where clause
.
Recordsets & QueryDefs
Recordsets and querydefs are the bread and butter method of Access programmers, the simplicity and power of these techniques are awesome, this is where you start to realy appreciate the phenomenal power of Access.
Creating Tables using DDL, DAO and ADOX
This article discusses the use of several different techniques which can be used to create tables; DDL, DAO and ADOX.
Domain Functions
Domain functions are a double edged sword in your arsenal of techniques, when used correctly they enable the quick retrieval of data, used incorrectly they can cause performance overheads.
Application Administration
Access Database Security
This article provides a brief dicussion of some of the choices to be made when considering Access Database Security, it includes links and some popular code which can be used to pick up a users windows login name and assocaited links to other articles.
Maintaining Access Databases - Compact, Repair & Decompile
This article provides an introduction to the issues surrounding maintaining an Access database, topics include the use of the Decompile switch, oplocks and ldb files.
Sandbox Mode In Access 2003
This is a somewhat older article and provides pointers for dealing with a number of issues relating to sandbox mode in Access 2003.
Query Statistics & Analysis Of Performance - Comments On Access & SQL Server
This article discusses performance of Access databases, and gives a number of suggestions for tracking down problems.
Documenting Access Databases
Documentation is important,and the DAO/ADOX architectures expose appropriate information, this article gives pointers in building your own documentation utility.
Access 2010 Web Databases
Converting Access Databases to Access Web Databases
This article describes how to modify the structure of your tables and relationships in a Client Access Database to allow conversion to an Access 2010 Web Database.
Access 2010 Referential Integrity, Lookup Wizard and Web Databases
This article provides details of enhancements in the Lookup Wizard for supporting Web Databases.
Access Web Databases: Setting a Default on a Lookup
This article shows you how to write BeforeChange data macro's to set default values for a lookup, and how to avoid common problems when doing this.
Copyright © 2009 ASC Associates,
Technical Support
support@ascassociates.biz
,
Sales Enquiries
sales@ascassociates.biz