Recent content by msaccessken

The background: 1. I will be working with Access 2003. 2. My back-end databases will be sitting within the .mdb file and powered by the JET engine (i.e. no connection to SQL Server, Oracle, etc.) 3. I will be writing SQL within my VBA code for purposes of automation. For example, querying...

Situation: Short term, application will be 100% MS Access-contained. Databases sit within the .mdb file. VBA and embedded SQL code will deal with the Jet databases. Long term, there is a possibility of migration from a fully contained MS Access environment in that the VBA will connect...