Printable View
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 ..
have you considered that perhaps your ado drivers need updating. it could be the problem
Do u know the exact url that i can find the latest ADO drivers ??
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
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.
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 ???
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.
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