
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