Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer 
Author Message
 Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

After I have installed the ms/Jet engine compatibility layer for the
Visual Basic 3.0 is not more successful to access data with the ODBC driver
interface .

I can still see my data base like access 2.0.
But when I try to access it like an ODBC data base
the sample program supplied by microsoft in
the c:\ vb\samples\ visdata returns a reserved error.

My data base is very simple.
It consists just in a table named as table1
where a text field is defined like unique key.



Mon, 14 Dec 1998 03:00:00 GMT  
 Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

Quote:

> After I have installed the ms/Jet engine compatibility layer for the
> visual basic 3.0 is not more successful to access data with the ODBC driver
> interface .

> I can still see my data base like access 2.0.
> But when I try to access it like an ODBC data base
> the sample program supplied by microsoft in
> the c:\ vb\samples\ visdata returns a reserved error.

> My data base is very simple.
> It consists just in a table named as table1
> where a text field is defined like unique key.

There is no way get to ACCESS 2 from VB 3 using ODBC unless you
program directly to the ODBC API (you must bypass the Jet engine,
which is what is returning your error).

I believe I have read that MS has fixed this issue with Access 7.

Good luck.

--
Karl Costenbader, President
Competent Consulting
Sacramento, CA

Home Page: http://www.competent.com



Mon, 14 Dec 1998 03:00:00 GMT  
 Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

Quote:

>I believe I have read that MS has fixed this issue with Access 7.

I'm not sure if its fixed or not, but what would be the point?
The Jet engine can access the .mdb files directly.

Joe

Never underestimate the power of a WAG.

http://www.citilink.com/~jgarrick



Tue, 15 Dec 1998 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. VB3 - Access 2.0 Compat Layer compact problem

2. Problems accessing Access 2.0 via ODBC 2.x from VB3.0

3. Accessing Access 2.0 databases with Jet 3.5

4. Access Jet Engine 2.0

5. VB and Jet Engine of Access 2.0

6. MS Access 2.0/MS Jet 2.0 Locks

7. Problems accessing ACCESS 2.0 databases from ODBC

8. Access 2.0 compat. layer

9. Trouble getting a VB3/Access Jet 2.0 DB App to run in NT4.0

10. Trouble getting a VB3/Access Jet 2.0 DB App to run in NT4.0

11. Access 2.0 Through Jet or ODBC w/ VB4?

12. HELP: ODBC with Access 2.0, VB3.0, and Data Control

 

 
Powered by phpBB® Forum Software