Write protection of DB

[Countdown]

Hi,

Is there a way to tell MS Access not to write/read protect a database when it opens it?

Trying to do a webapplication that uses some tables in a .mdb database, it is working together with another program that is programmed in MS Access. But the other program locks the db while it is using it. Anyway to change that?

Thanks for any help
Mattias

 

[The_Doc_Man]

Both programs have to be part of a workgroup such that you can specify a non-exclusive reference. Or when you explicitly open the database, do not attempt to get it exclusively.

Inside the "other" program, whenever you open a recordset, you must specify the argument of the db.openrecordset method that allows you to control how you lock - or don't lock - that recordset.

Both your web program and your "other" program have to follow the same conventions on how you open things, by the way. The biggest problem with locking shared resources is that everyone MUST play by the rules or you might as well have no rules.

 

[Countdown]

Hi again and thanks for your reply.

Only problem I have is that I havent created the "other program". Im only using the DB it is using. Guess that means I can't do anything about it then.

Mattias