Problems with MS Access using ADO

[winsonlee]

There isn't any problem when i run the program using the MS access 97 file format . But after converting the ms access file to MS access 2000, and i run the program, there is an error saying "Run time error '-2147467259 (80004005)': Unrecognized database format 'c:\windows\desktop\ADO\db1.mdb'. May i know this problem is due to what reason ???

For your information i am using ADO to connect to the access database ..

[GoddMapp]

have you considered that perhaps your ado drivers need updating. it could be the problem

[winsonlee]

Do u know the exact url that i can find the latest ADO drivers ??

[GoddMapp]

http://www.microsoft.com/data/download.htm

took me less than one minute to find on a 56k connection. you should try msdn search sometime after all that is what it is there for

[medaugh]

Have you tried changing your connection provider from Jet 3.51 to Jet 4.0? I had the same difficulty with an Access 2000 db.

[winsonlee]

I have set the database password for my ms access file.
What is the code that i need to use to open the database ???

mCN.ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & strPath & ";PWD=123"

I have tried using the code above, but there is an error msg saying "Run time error, Could not find installable ISAM". May i know this problem is due to what reason ???

[medaugh]

I checked the msdn site and found this article for your error message: http://msdn.microsoft.com/library/de...ootingtips.asp Not sure if it will help. It almost sounds as if Jet 4.0 is not loaded.

[Ecniv]

Passworded Access Dbs were discussed on a previous thread.

Use the thread search (see top of window) and have a look for password access mdb and see ... I think if was a property of the connection that had to be added.

Regards

Vince