VB with Access 2000 3

[redsand]

I have vb app that is using an access database. I have coverted the db to 2000 and am getting unrecognized database format when opening the vb app. I am running mdac2.6.

Dim rs As Recordset
Dim db as Database

strAppDir = App.Path
strDBName = strAppDir & "\VenRate.mdb"
Set db = Workspaces(0).OpenDatabase(strDBName, False, False)
bExclusiveMode = False

Can anyone provide insight on where to go from here.
Thanks in advance.

 

[vb5prgrmr]

Which library are you referencing? Needs to be DAO 3.6.

Good Luck

 

[BlackburnKL]

ADO will work fine. Microsoft ActiveX Data Objects 2.6 should be able to handle it useing the Jet Engine version 4 or later. BlackburnKL

 

[johnwm]

Make sure you have VB6 SP5:

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/dnldoverview.asp

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

'People who live in windowed environments shouldn't cast pointers.'

 

[redsand]

That did the trick thanks guys!!