Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is Microsoft Jet-connected ODBC data source?

Status
Not open for further replies.

amrizvi

Programmer
Jun 21, 2011
8
AE
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
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.

What is Microsoft Jet-connected ODBC data source?
Is this mean ? any of following

Example 1:
MS Access Database opened through OpenConnection from ODBC
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”)

OR

Example 2:
MS Access Database opened through OpenDatabase from ODBC
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")

In this case, I am receiving following errors
3423: You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database.

OR
Something else?
Please explain with example code

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top