ACCDB to ACCDE file

I have created a accdb database. It has been split with a back end and a front end. It has record locks on each form:

Private Sub Form_Load()
Me.AllowEdits = False
End Sub

I placed the link to my front end database on our company website so that our Supervisors can use the Form Buttons to see prior data production, late items, etc.

When I was using the link to a .accdb file it wouldn't allow more than one user or we receive the message "You do not have exclusive rights, etc."

So I then saved the database as a .accde file. It allows multiple users but does not keep the record locks on the form, the supervisors can alter the data. I want to lock the form as far as editing the data but I still want them to be able to filter the form and then export the data to excel via a button at the top of the screen.

Please help! Thanks!

i can't help - but would say generally that specific record level locks are not likely to be needed in most databases.

... and even if you do implement Record Locks, you need to know what you're doing and have some in-depth knowledge on the subject.

Turn off record locking and let Access handle it.

I think OP meant that the code snippet provided is record locking.

You say that the users run the frontend by clicking on a link. So all users use the same frontend?

Hmmm... it could be spikepl.

@konaan1: In that case, why are you setting the AllowEdits property in code? Why don't you just do it in the Property Sheet and save it.

Also, how are your users accessing the Front End? Is it in a shared location?