front end back end question

[travismp]

access 2000 with 30 users. 10 of which enter info. rest just use for reference.

I have all tables on network server all users get a front end access version with all queries, forms, reps, ect. Now I think I need to enable record locking but do not know what to do.

Do I enable record level locking for just the back end or only the front end systems? what is the best way to set it up? thanks.

t~

 

[Oldsoftboss]

Do you have a log in system incorporated in your Db ?
If so, you can include user levels and make each form to AllowAdditions = False, AllowEdits = False, AllowDeletions = False

Another option is to create a second version front end with all the fields locked and disabled, then distibute this to the users that require read-only access.

Dave

 

[travismp]

no log in system. Bottom line should record level locking only be set on the front end systems or the back end db?

 

[Wiz47]

Do you have a log in system incorporated in your Db ?
If so, you can include user levels and make each form to AllowAdditions = False, AllowEdits = False, AllowDeletions = False

Another option is to create a second version front end with all the fields locked and disabled, then distibute this to the users that require read-only access.

Dave

I created a Restricted front end and distributed that to the users that need read-only access. The original db is called mydb and the Restricted one is Mydb_r (so it's easy to tell who has what when looking at it from the IT side of the house). The Restricted db has all fields locked, so there is no chance that someone could get hold of someone's all-access password and get in. They will still only have access to the restricted version unless they are using my computer or someone elses computer that has all access to the records.

 

[travismp]

I am not worried about the read only people right now. Bottom line question: when running a front end and back end DB at what point do you enable record locking on the DB? Do I check record level locking on the frontend dbs or the backend DB?

 

[Wiz47]

I am not worried about the read only people right now. Bottom line question: when running a front end and back end DB at what point do you enable record locking on the DB? Do I check record level locking on the frontend dbs or the backend DB?

I have the advanced option set to Open Using Record Level Locking on the FE.

 

[travismp]

perfect. That was exactly what I wanted to know. Thanks. Have a good morning.