ACCESS 97 vs 2000 database access via VB??

[hall]

Help! I have a Microsoft Access 97 database that I have been accessing/adding/deleting/querying records from using VB 6 code. I have been opening the database using a standard DAO opendatabase command shown below where "db_location" and "database_password" are variables stored in code.

Set db = OpenDatabase(db_location, False, False, ";PWD=" & database_password & "")

Recently, this database was converted to Access 2000. Now, when trying to open the database via my VB code, I get a runtime error '3343 Unrecognizable database format' on the above opendatabase command. From the article below, this is to be expected. The proposed resolution to the problem is to download a special service pack from the location below that contains a dll file that needs to be referenced in your project ‘Microsoft DAO 3.6 Object Library’. I did this and now I get a ‘3633 Runtime Error’. Has anyone had the same experience? Any ideas on what to do next?

Article:

http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

Service Pack Download:

http://msdn.microsoft.com/vstudio/sp/vs6sp4/vbdownload.asp?id=10

Thanks
KBH

[jbrown99]

I had the problem but dao 3.6 worked fine
why not just convert the database back to 97
and use as it was

Hi, i did have the same problem even with dao 3.6 and i was forced to use ADO Recordsets and even with this i had problems with the OLEDB jet provider. to solve this i used a DSN. before that i converted my Access-2000 database to the earlier version and used ADO so that in future if i get a solid solution i can just maybe change the DSN. would very much like to know the solution please.

[WVTR]

Hi,

Your run-time 3633 is easily to resolve. Just read my reply on a simular question:
http://forums.vb-world.net/showthread.php?threadid=26492

Hope this helps!!!!!! I'm sure it will. It helped me!!!!

WVTR