Shared and exclusive databases

[habbabub]

I was just wondering what the drawbacks for using Shared and exclusive databases.
id like to create a shared database but has anyone come across any problems?

what happens when 2 people at the same time access the same row and save at the same time? is the first persons work get overwritten?

 

[MStef]

Study and test RECORD LOCKS properties (form properties).

 

[Dennisk]

Access handles multi user concurrency automatically and will display an icon against a record if another person has edited it.

 

[GohDiamond]

I use an MS Access 2003 database with 20+ concurrent users in an institutional setting. If there's one bit of advice I can give you in addition to all the great advice that has just gone before. To avoid the conflict make sure that all your tables are addressed by queries and that all your forms use the QUERIES not the TABLES as their source when building the form. This will buffer the entries and the liklihood of 2 people completing entry into the record at the same time is almost nil.

Any number of users can view the same record at the same time.

I hope this helps.
Cheers!
Goh