: set MyDB = OpenDatabase("",false,false,"ODBC;")

: After we select the Access2.0 database we get Error No: 2034
: which has no documentation.

: Is this possible?  Can anyone help us?

: Thanks
: Leanne Stirling
: Megan Grenenger

Microsoft has a list of Reserved Error codes they faxed me.  Error -2034 is
concerned with trying to access MS Access via ODBC.  They promised me that
this will not happen when using something like SQL Server.  Try using
Access directly (not via ODBC).

: : set MyDB = OpenDatabase("",false,false,"ODBC;")

: : After we select the Access2.0 database we get Error No: 2034
: : which has no documentation.

You have the compatibility layer installed, right ? Installing this
allows a direct JET connection to Access 2.0 and has the wonderful side
effect of causing error -2034 with any ODBC connections. Uninstall the
compatibility layer and see if this fixes it.

---

Hope this help!

--Mark!

------------------------------------------------------------------------------

: I believe that this was posted earlier, but here goes anway...
: Access 2.0 does NOT have an ODBC driver. I've heard Microsoft is working on one, but I
[snip]

Access 2.0 DOES have an ODBC driver. It is in the ODBC 2.0 Driver Fulfillment
Kit, available now directly from Microsoft. If you still don't believe it
Mark, I'll email you the Microsoft document which describes it. Check out
the knowledge base articles at ftp.microsoft.com, because several new
articles have been posted recently which discuss the 2.0 driver.

---

  from MSKB:  DOCUMENT:Q117900  18-OCT-1994  [VBWIN]

   -2034 You cannot use ODBC to attach an external Microsoft
              Access or ISAM database table to your database.
  this error is in the Access 2.0 help files under  "error messages: reference"
as far as I can tell VB-Access engine thinks it is creating an ODBC connection
to a SQL-server.  
   I have the  new ODBCadrivers on the system and and can preform querys on
the ODBC data base via Excel, therefore  I think the problem is in VB and the
way it connects to the ODBC subsystem.  

  If anyone has made this thing work let me know cause it would be a great
help to get ODBC working with my VB apps.

Kent

Dept of Agricultural Economics | GTE-Net: Office: 317-494-7642 Fax 317-494-9176
Purdue University              | GTE-Net: Home:   317-497-4240 Fax 317-497-4152
West Lafayette, IN 47907       | Administrivia: #include <standard_disclaimer.h>

:   I have ran into the same problem ,
:   I have done some looking around on this and as far as I have found is

:   from MSKB:  DOCUMENT:Q117900  18-OCT-1994  [VBWIN]

:    -2034 You cannot use ODBC to attach an external Microsoft
:               Access or ISAM database table to your database.

We had a VB app talking to Access 1.1 via ODBC. It worked fine until the
compatibility layer was installed - then we got error -2034.
Try uninstalling the compatibility layer - using Microsoft's wonderful
uninstall program ;-)

---

If you are using JET 2.x you CAN NOT connect to an
Access database using an ODBC driver unless you are
coding directly to the ODBC API. There are no
advantages that I can think of in trying to use an ODBC
driver to connect to an Access database. Use JET to
go to an Access database and use an ODBC connection
to go to other databases, your code is not going to
change if you switch from an Access database to SQL
Server using an ODBC driver.

Hope this helps.

Greg Hinkel
Microsoft Developer Support

Dept of Agricultural Economics | GTE-Net: Office: 317-494-7642 Fax 317-494-9176
Purdue University              | GTE-Net: Home:   317-497-4240 Fax 317-497-4152
West Lafayette, IN 47907       | Administrivia: #include <standard_disclaimer.h>