
HELP: ODBC with Access 2.0, VB3.0, and Data Control
We have a client trying to use our ODBC "Spy" Driver with MS
Access 2.0. Their development environment is MS
Visual Basic 3.0.
Our "Spy" driver must use another ODBC driver to do the actual
interaction with the underlying database (just for a quick
explanation without disclosing any trade secrets! :-)
The Problem:
------------
In order to use ODBC, our client switched from using the Jet
Engine to using ODBC API calls within his VB project. Things
ran smoothly until he tried to access his data from a data
control. His error message said basically, "If you want to use
this data control with MS Access, you gotta use the Jet Engine."
Apparently, it would work fine with a different database and
ODBC.
The Restrictions:
-----------------
Our client cannot invest any more time trying this with other
databases. Our client does not have VB 4.0. Our client does
not have MS Access 7.0.
We have VB 4.0 and MS Access 7.0, but do not have our client's
versions.
The Questions:
--------------
1) Does anybody know if this is really possible with Access 2.0
and VB 3.0?
2) Does anyone out there know of a data control that is "ODBC
Friendly" to MS Access?
3) On a different note: Does anyone know of an ODBC driver for
MS Access that supports the SQLPrimaryKeys function? The one I
have (from Microsoft) does not.
If I have been at all unclear in this post, please e-mail me and
I'll try to explain further.
Thank you for your time!
Please Note: I've set Followups to the
comp.lang.basic.visual.database newsgroup.
--