Loading

connecting to ms access exception(ISAM)

lalitha

TRYING TO ESTABLISH A CONNECTION TO ACCESS USING C# CODE CREATED AN EXCEPTION INSTALLABLE ISAM..CHANGING THE CONNECTION STRING TO "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +sourceFile + ";Extended Properties=\"Excel 8.0;HDR=NO;\""" PRODUCES A NEW EXCEPTION"Cannot update. Database or object is read-only." PLZ HELP

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

virendra a17y ago
Hi lalitha,
I guess there is a problem with your connection srtring.
Use Jet engine for connecting to MS-Access.Set your connection string as : "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\abc.mdb"
replace abc.mdb with your file name.
Just access this con string in your C# code and you will be through.