Web Development

Ask something
Discussion Locked

Connection to access database from VB

0 helpful
4 replies

by mtcsoftware

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

thanks

mike lortie

4 replies

by willmarpo

Mike:
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.

by julianj

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.

by rrv

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.
RV

This discussion is closed to new replies.