question

[tassosp]

Apologies if you've read this twice, I also post it in the general forum. There's this problem that's bugging me for a few days now.

I have created a very simple VB application for a friend. I've used Microsoft Access 2000 and Visual Studio 6.0, working in a Windows 2000 Professional environment. This application reads information from a .txt file and creates new entries into the database which the user can update or delete.

The problem is that my friend has Windows 98 and another version of Microsoft Access (which I don't remember exactly). As a result the program cannot run properly. As I used the .exe file, I couldn't debug, but I suspect strongly that it all goes wrong when I try to make the connection with the database. The commands I'm using are:

connect = "DSN=dbRecords;UID=;PWD=;"
stm = "select * from tblRecords"
rs.Open stm, connect, adOpenStatic

where dbRecords is the database and tblRecords is a table in dbRecords.

In my PC, I have declared the database in ODBC as Driver do Microsoft Access. In my friend's PC, this option was not available, so I chose Microsoft Access Driver. I thought that since the .dll was the same, it wouldn't make any difference. Could this possibly be the source of the problem, and what do you suggest about it?

Thank you so much for reading this; any suggestions will be more than welcome. Thank you so much.

[BG]

Make sure you are using the same version of mdac that you used when you compiled the application, mabe? what error does it throw at you.