Multiple users entering data on FE cannot corrupt database, can th

[Guest]

I have a BE database on server and the FE database on eight workstations
where four users enter data (from the FE) into the database at the same table
and same data.
My only question is, I am afraid this may not last long, so was wondering if
you guys could tell me if this is a safe way of entering data at the same
time same table.

Thank you for any help provided!
Adnan

 

[Arvin Meyer [MVP]]

You are doing it the safe way. The ldb file prevents users from changing the
same data at the same time. If the users try to change the exact same data
(or even data on the same page of data, at the same exact time, the ldb file
will stop them.

 

[Guest]

So there is no way the database can get corrupted, right?
Thank you Arvin****
--
Please post all your inquiries on this community so we can all benefit -
Thank you!

You are doing it the safe way. The ldb file prevents users from changing the
same data at the same time. If the users try to change the exact same data
(or even data on the same page of data, at the same exact time, the ldb file
will stop them.

 

[Douglas J. Steele]

Arvin didn't say there was no way the database can get corrupted. All he
said was that the ldb file would ensure only one user at a time can update a
given element of data. Corruption can still happen.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

So there is no way the database can get corrupted, right?
Thank you Arvin****

 

[Guest]

Understood. Thank you Arvin and thank you Douglas! I appreciate you help.

Adnan

 

[Arvin Meyer [MVP]]

Corruption normally occurs when data is interrpted during a write to disk.
It can happen with any file, but since Access has typically larger files, it
happens more often with Access. I have not corrupted a database (with 50
users) in over 3 years.

 

[Guest]

Arvin, I love your answer, this is what I wanted to hear.
THANK YOU SO MUCH!
Adnan