Web Development

General discussion


Connection to access database from VB

By mtcsoftware ·
Hi all and thank you in advance.

i have an application which was developed in VB6. it connects to a database and works fine - except. i just had an individual install the application on an computer with XP and now there is no connection to the database. should there be a difference if the database is an access 2000 database and the machine has accessXP. i personally dont think so, since the application uses the same connection string to connect to the database.

it works fine on machines from windows 95 to 2000. any ideas what i might be missing?


mike lortie

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by willmarpo In reply to Connection to access data ...

In fact, there was a compatibility problem between Access 97 and Access 2000, since the later changed the file formats. So, It would not be so illogical to think there is an incompatibility issue here too.
Depending on the technology used to connect (ODBC or DAO)the fix for this could be as simple as to open the mdb and save it as the newer access or to reinstall Access to the lower version or changing the ODBC driver.

Collapse -

by JulianJ In reply to Connection to access data ...

Dear Mike,

What type of connection or database access method is used for the VB6 program? Is it DAO, ADO? Are you depending on a DSN to connect to the database? My guess is that you may need a DSN to be created for the database. If that is the case, you may need to create a DSN in the ODBC data source dialog. You may need to get the DSN that is used in the program code used by your VB6 application first.

Hope that helps.

Collapse -

by RRV In reply to Connection to access data ...

Hi. Good you upgraded and it is more better indeed. First thing you do is open Microsoft Query which you can find in C:\Program Files\Microsoft Office\ folder. Using MSQuery use your dsn which your program uses or use the same connection string and connect to your access 2000 database. If you are able to run a normal select query, your database is fine. In that case MDAC is also fine and working properly. All you have to find is that default location where your program is looking for the database.
Good luck.

Collapse -

vb to access

by span_545 In reply to Connection to access data ...

connection to vb and accesss

Related Discussions

Related Forums