lock access databse

[JohannIcon]

Dear All,

I need to lock an Access Database, so that, while I am writing in it, no other user can write at the same time. How can I do it?

Thanks for your help and time

 

[onpnt]

http://www.w3schools.com/ado/prop_rs_locktype.asp

http://www.w3schools.com/ado/prop_rs_cursortype.asp

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[JohannIcon]

Sorry I forgot to mention that I am trying to lock a Dataflax database and those commands (which I have already tried) do not work.

But thanks for your help

 

[onpnt]

try the forum898 DataFlex forum then. may help a bit more then us seeing as those memebrs are currently involved in the usage.
I did come up with this though with a search

http://www.webappdeveloper.com/asphosting.htm

http://www.dataaccess.com/whitepapers/TransactionsLockingandDataFlex.htm

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[JohannIcon]

Thanks ONPNT, I will try the Dataflex forum then

I took a look at those links you attached but did not find anything interesting.

Thanks again