Simultaneous access to database on server?

[gussy]

Hi folks

I've put together a database, which I'm now storing on the company's server. I notice (unlike an excel worksheet) that more than one person can open it simultaneously on their workstations, and access the same records simultaneously.

What happens if two people edit the same record simultaneously? I guess whoever presses 'enter' edits it first, but then it gets overwritten by whoever 'enters' second....

What I'm getting at, is there a way of having one exclusive user at any one time? Alternatively, is there a way of flashing up a warning/text box or something saying that someone else is editing or accessing the database?

I don't need a highly complicated solution involving pages of code, but if there is a simple way I'd really appreciate it.

Thanks all.

 

[namliam]

Open the db with the switch /Excl to open it exclusively locking out all other users.

Or in the options/advanced set default open mode to Exclusive (does the same as the above switch)

Or in the same tab change the default record locking settings... to either all records (locking the table) or editted record only (by default its set to no locking)

I hope one of above ideas will help you...

Regards

 

[gussy]

Great stuff, thanks for that.