Hi,

I tried to connect to Microsoft Access with Visual C++, but it was failed. The following statement is my connection string.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\db1.mdb;UID=admin;PWD=apple"

Error message:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
If I remove the part "UID=..;PWD=..", it works fine.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\db1.mdb"
What should I put into UID? It seems Access just allowed me to setup password.
May you help me to find out the problem is?


Thank you!