VB3 using Access 2.0 db thru ODBC 
Author Message
 VB3 using Access 2.0 db thru ODBC

Hi

I hope someone out there can help.  I'm using VB3.0 and I have
an Access 2.0 database that I'm accessing.  I'm just using the Data
control and I'm connecting a label to a field in the Access database.
I'm doing this through ODBC, so my connect string for the Data
control is "ODBC;DSN=whatever".  This works in VB3.0 on my machine,
both in the VB environment and as an .EXE.  
But when I install this program on others' computers, it won't work.
I get an error 2034 (no message for this error), which probably is
the message that I can't use ODBC to attach an external Access db
table to your database.
But why does it work only on my machine?  I've tried it on 3 other
machines - it works on one of those.  The datasources and Access
drivers for ODBC are set up on all of them, but only the machines
with VB3.0 on them seem to work.  The other machines can use the
same datasource and read/write data from non-VB applications.
I've made sure vbrun300 (obviously) is on them, as well as vbdb300,
msaes110, msajt110 and numerous other dll's which WPS told me were
open.

The VB3 data control won't read the Access 2.0 database, it only
likes older versions of the database.

I've spent two whole days on this now...what are my options?  Putting
VB3 on these machines is not feasable.

I'd appreciate any help on the matter

Jason Wright

--




Mon, 28 Sep 1998 03:00:00 GMT  
 VB3 using Access 2.0 db thru ODBC

Quote:
> Hi
> I hope someone out there can help.  I'm using VB3.0 and I have
> an Access 2.0 database that I'm accessing.  I'm just using the Data
> control and I'm connecting a label to a field in the Access database.
> I'm doing this through ODBC, so my connect string for the Data
> control is "ODBC;DSN=whatever".  This works in VB3.0 on my machine,
> both in the VB environment and as an .EXE.  
> But when I install this program on others' computers, it won't work.
> I get an error 2034 (no message for this error), which probably is
> the message that I can't use ODBC to attach an external Access db
> table to your database.

Get the following patches to allow your app to always use
Access 2.0 MDB's natively, as well as other goodies:

<ftp://ftp.microsoft.com/softlib/mslfiles/comlyr.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/accsvc.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/vbrun300.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/vbdb300.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/ww1000.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/ww1116.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/setupk.exe>

[chomp]

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!



Tue, 29 Sep 1998 03:00:00 GMT  
 VB3 using Access 2.0 db thru ODBC
Hi Jason,
        What you need is the jet Access Compability Layer. This will allow vb3
to read access 2.0 files. Also you shouldn't have to use ODBC with access since
it as built in support for it. Also make sure that you include with your .exe
all the dll's that your application requires. I hope this helps you.

Stephane ..



Sat, 03 Oct 1998 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

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

3. Using the COUNT function in Access accessing db2 tbls thru ODBC

4. CONNECTING TO ACCESS DB THRU ODBC WITHOUT DSN REMOTLY

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

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

7. Help: Problem connecting VB3 app to Access 2.0 w/ODBC in Win-OS/2

8. Bitmap Handle to BLOB (Long Binary) in Access 2.0 DB with VB3

9. VB3.0 & Access 2.0 DB

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

11. Help: Problem connecting VB3 app to Access 2.0 w/ODBC in Win-OS/2

 

 
Powered by phpBB® Forum Software