a database installed on network

[virginie]

here my question :
i build a little application database-oriented.

now i have a problem:

if the application will be on the network- on all people computers, so how it will be with the database?

how can i set the application as locked or something else to avoid 2 people to use it at the same time??

if 2 people open the appl. at the same time, all the indexes in the tables will be wrong, a real mess...

do someone know how to do that?

 

[KenReay]

Hi

There is an option on open to open exclusively (ie only one user at a time), or withint the application, when you open a table, you can open it and lock it exclusively.

But why do you think > 1 user will mess up your indexes, Access can handle record locking etc........ Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK