Multiple users - question

[Joshinkii]

Hi guys.

I am currently working on a ms database which only 5-6 people will be using. This will be hosted on a shared folder on one computer.

Nobody will be creating forms or anything only changing records or adding records.

Can multiple people change and add records at the same time?

Thanks guys

 

[namliam]

Sure shouldnt be any problem, just cant change the same record at the same time

 

[Joshinkii]

Thanks.

Will the user get a message if the record is already being edited?

 

[namliam]

They will get a message after editting and before saving it that "It has been changed by another user you cannot save now" or something along those lines (IIRC)

 

[Joe8915]

save the heart ache and split it. belive me this come from experience. just my 2 cents worth

 

[David R]

What Joe said. You'll spend more time chasing corrupted tables and table locking than you will just splitting. Plus it'll run faster for the end users!

Investigate boblarson's UpdateFE code/tool to make updating 5-6 front ends a breeze.