What is Microsoft Jet-connected ODBC data source?
Actually I am using MS Access Database and working with VBA and want to use object.EXECUTE dbSeeChange which is only available with Microsoft Jet workspaces and also want to work with External MS Access Database defined in ODBC (Data Source).
As per help
Is this mean ? any of following
MS Access Database opened through OpenConnection from ODBC
Example 1:
OR
MS Access Database opened through OpenDatabase from ODBC
Example 2:
In Example 2, I am receiving following errors
Something else?
Please explain with example code
Actually I am using MS Access Database and working with VBA and want to use object.EXECUTE dbSeeChange which is only available with Microsoft Jet workspaces and also want to work with External MS Access Database defined in ODBC (Data Source).
As per help
What is Microsoft Jet-connected ODBC data source?Note : When you access a Microsoft Jet-connected ODBC data source, you can improve your application's performance by opening a Database object connected to the ODBC data source, rather than by linking individual TableDef objects to specific tables in the ODBC data source.
Is this mean ? any of following
MS Access Database opened through OpenConnection from ODBC
Example 1:
Code:
Dim mWS As Workspace
Dim mCON As Connection
'Workspace
Set mWS = CreateWorkspace("", "admin", "", dbUseODBC)
'Connection
'SIR-Tec = a User DSN already defined in ODBC (Data Source)
'with Microsoft Access Driver and Select Database path is D:\Access.mdb
Set mCon = mWorkODBC.OpenConnection("", , , ODBC;DSN=SIR-Tec”)
MS Access Database opened through OpenDatabase from ODBC
Example 2:
Code:
Dim mWS As Workspace
Dim mDB As Database
'Workspace
Set mWS= CreateWorkspace("", "admin", "", dbUseJet)
'Connection
'SIR-Tec = a User DSN already defined in ODBC (Data Source)
'with Microsoft Access Driver and Select Database path is D:\Access.mdb
Set mDB = mWS.OpenDatabase("AnyName", dbDriverComplete, False, "ODBC;DSN=SIR-Tec")
OR3423: You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database.
Something else?
Please explain with example code