Questions regarding SQL syntax within MS Access

[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 the database and then using the information to update MS Office documents (Word/PPT/Excel).

My question:

When I write the SQL code within my VBA, does the syntax have to be JET SQL for it to work? If I use T-SQL, for example, will it fail?

The follow-up question:

If eventually I migrate the databases from MS Access / JET to SQL Server or Oracle, will I have to rewrite my SQL to follow the correct syntax? I.e. converting JET SQL to T-SQL

 

[JohnAngus]

I am no expert on this but I have converted a total application MS Access to a dot net program using SQL Server at the back end. My experience was that I had to re-write lots of the SQL to suit SQL Server - nothing major but there were lots of small querky things - one small example that I remember was that you cannot use the "*" in SQL Server that you use as a wild card in MS Access.

As I say I am no expert but that is my experience.

Hope this helps.

JohnAngus