|
How to: Connecting to MS Access Databases using the standard Oledb object
Besides using the custom MS Access object, you can also connect to an Access database using the standard OleDb drive in conjunction with the Jet Oledb Driver. MDAC (Microsoft Data Access Components) provides a Jet OleDb provider for use with MS Access Databases, as well as several other types of data including Excel, dBase, Paradox, and Text.
To connect to an Access database simply select the Microsoft Jet OLE DB Provider and set the Server property to the path and filename. Then use it like any other database where you would define the ColumnLayout and specify a Tablename.
© 2003 - 2007 Relational Solutions, Inc. - All rights reserved