Existing VB 5 Project Can't Open Database in VB 6 2

[drosenkranz]

Hello,

We recently upgraded to XP's with Access 2002 in our building. I have a number of large VB5 (SP3) projects running using DAO and Access '97 databases with security.

Since I can't adminstrate an Access '97 table from Access 2002, I converted the database to both Access 2000 and an Access 2002 format - each time with no luck using the OpenDatabase command. This should be simple but I've been at it for a while with no luck.

'Connect string
strConnect = ";DATABASE = " & (mstrAppPath & mstrMDB) & _
" ;UID=" & mLogID & " ;PWD=" & mLogPW
'Create Database Object
Set mdatW2W = OpenDatabase("", True, False, strConnect)

Any suggestions would be greatly appreciated,

Dave



The 2nd mouse gets the cheese.

 

[johnwm]

You probably need to upgrafe your MDAC on the client machines. I believe that for DAO/Jet you need MDAC 2.5 from:

http://www.microsoft.com/downloads/...78-94c9-4e7d-b0b6-a8a94c4eb912&DisplayLang=en

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[drosenkranz]

Hello johnmw,

Will installing an older version of mdac interfere with any of the newer software running on the XP's?

Thanks,

Dave



The 2nd mouse gets the cheese.