PDA

Click to See Complete Forum and Search --> : VB5 to VB6 Cannot Access Access DB


HunterMcCray
Aug 25th, 2000, 09:27 AM
I have recently upgraded from VB5 to VB6. I have written a front end using VB5 for an Access Database located on one of three computers in a peer-peer network. Because the program ultimately runs on all three computers the Directory of the database is contained in a small .dat file on the same directory where the .exe file of the running application is, there is code to update the database's directory based on information contained in the .dat file at runtime. All of this works wonderfully in VB5; however, the same source code fails in VB6. The VB6 environment prompts for "Select Data Source", and then when the database is selected gives the error code is #3423 "You cannot use ODBC to connect to a Jet...". I am certain that I am doing something very simple wrong, but it is driving me crazy. The good news is that I have not yet un-installed VB5, and I can still work on my code. Any suggestions would be helpful.

Hunter