Microsoft Access Links

Hey, I like Access... it just works. Sure it's not the best database, but as an integrated data and analysis tool, it's great. Choose the right tool for the right job... and many times, that's Access.

Here are some MS-Access resources.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q209126& - query optimization kb article.
http://www.utteraccess.com/ - Formerly athree.com. One of the best peer-to-peer Access sites (or any peer to peer support sites) that I've ever found. When in doubt, go there. And GoogleGroups.

http://www.utteraccess.com/links/index.php3 - they've got a good list of access resources and sample access databases too.

A good document on converting from DAO to ADO.
http://www.msofficemag.net/features/2000/01/vba200001sf_f/vba200001sf_f.asp
Create ODBC DSN's via code: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q184/6/08.ASP&NoWebContent=1
Interesting site: http://www.granite.ab.ca/accsmstr.htm
Good post on Deja about Reference issues in access. http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=37cb29ff.14567233%40news.xs4all.nl&rnum=14&prev=/groups%3Fq%3D%2522Execution%2Bof%2Bthis%2Bapplication%2Bhas%2Bstopped%2Bdue%2Bto%2Ba%2Brun-time%2Berror%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DN
Another site with a quality list of links and tips.
http://members.iinet.net.au/~allenbrowne/ser-41.html
These guys have the Access 2000 Runtime available as a download.
http://www.amicron.com/AccessRT/