vb123.com.au
Find out about ADO and DAO and lots of the material discussed in this article http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate.asp Database provider constants for provider Microsoft.Jet.OLEDB.4.0 http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefjetprovspec.asp Probably the best page on this topic http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate_topic4.asp Access Provider default values for ADO http://msdn.microsoft.com/library/en-us/ado270/htm/mdproproviderx.asp Discussions on the MSDASQL provider (ODBC) with ADO. http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefodbcprovspec.asp HOWTO: Automate a Secured Access Database Using Visual Basic http://support.microsoft.com/default.aspx?scid=KB;EN-US;q192919&FR=0 This page shows you how to shell out Access to use a path http://www.mvps.org/access/modules/mdl0036.htm If you are going to use DSN files, a good place to start would be http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefodbcprovspec.asp
Other Pages
Microsoft Access Security And Passwords
Backing Up Your Access Data With XML
A Wizard To Turn SubDataSheets Into Shaped ADO Recordsets
Persistent Caching >>>Take a Load Off Your Server with Access 97/2000
Click on the
button for the next links page.
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number
of popular computer magazines, is now a book author and has worked on
100+ Access databases. He is based in Sydney, Australia