Search results
-
M
Questions regarding SQL syntax within MS Access
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...- msaccessken
- Thread
- Replies: 1
- Forum: Modules & VBA
-
M
Help: Planning ahead - database migration from Access/JET to SQL Server/Oracle/other
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...- msaccessken
- Thread
- Replies: 0
- Forum: Modules & VBA