Hey all, i am in need of some help with figuring out how to go about opening the access database that links to cobol tables. Problem is, when i try to read files from it and someone else is already using the cobol db then it doesn't allow any access. It has a type of lock on it i think.

Is there anything in the connection string that i can use to keep it all from being locked since i only want to read from it and not write/update?

My connection string looks like this:
Driver={Microsoft Access Driver (*.mdb)};Dbq=\\server1\jobs\ft\Fts\db\FODBC.mdb;"
Any help/ideas/suggestions would be great!