Where is Access documentation on http://msdn.microsoft.com/library?

[Siegfried Heintze]

Where do I find documentation on MSAccess SQL and APIs?

I looked in http://msdn.microsoft.com/library but could not find it.

 

[Michel Walsh]

Hi,


If you meant, Jet, that is the DAO library.


Hoping it may help,
Vanderghast, Access MVP

 

[Siegfried Heintze]

Where is the documentation on MSAccess SQL?

 

[Michel Walsh]

Hi,


Access is an application working with databases, not a database
itself. Access can natively work with either Jet (dot-mdb files) either MS
SQL Server (dot-adp files). I don't think there is a complete catalog about
SQL features in Jet, and note that you can use any VBA public function in a
standard module when you use Jet from within Access.

Try http://support.microsoft.com/default.aspx?scid=kb;en-us;321266 for a
list of reserved words, and
http://support.microsoft.com/default.aspx?scid=kb;en-us;275561


Hoping it may help,
Vanderghast, Access MVP