Frond end & Back end database question!

[jayanth1808]

Hi.. I am preparing a database for which only few people should have access to the main database... and all the team should be able to input the data at a time... So, I thought to do it with DAO recordsets.

My question is that... if all the team tries to input the data at a time, is there any chance that main database gets corrupted???

because I have prepared a database recently in similar way. after few days its giving me error message "database is corrupted, access is trying to recover the database" and its creating a new backup copy of main database.

Please advice me.

 

[Galaxiom]

Does each user have a separate copy of the front end?
Are all other users locked out when someone is in the backend?

 

[jayanth1808]

yes... each user will have a seperate copy of front end..!!!

 

[DCrake]

Why are certain users allowed in the back end. Surely this is restricted to the SA or DBA and should only be accessed exclusively.

If you have users with admin rights you should create an Admin front end that points to the back end.

David