Record Locking & Multi-User Access

[Adzi]

Hello,

I have a database, which is split into frontend/backend using the split utility.

I need to make it so multiple users have access. I though this was so, but everytime more than one person is using the system, a Run-Time error 2501 - the save action was cancelled.

I thought I set all record locks (locking edited records only) however this still isnt working.

Any advice?

edit: I have set in both systems;
Record locking - Edited Records
Access default - Shared

 

[oumahexi]

Can you be more specific?
Have you set a timer to lock edited records then unlock them again after a specified time? If all you have done is to tell the system to lock records once they are edited the will be locked until you specify when to unlock them.

 

[Adzi]

This is what I have set. Can you suggest anything then that would solve my problem?

The error occurs when the save command in my VBA is hit.

 

[Banana]

Actually, I don't think it's about locking per se.

It may be something entirely different.

You'll have to know exactly what line of code or Access event raises that error so we can help you out. If you don't know how to debug, click the second link on my siggy for information on how to get important information so we can help and answer your question.

 

[Adzi]

Every time it hits;

DoCmd.Save

I get the run time error.

 

[Banana]

and where is that line located at? What event is it firing under?

Also, does it always error or just occasionally?

 

[Adzi]

It's actioned by the user pressing a command button. I have many comand buttons, and the script always halts at the same save action.

It always presents an error message, no matter which command button is hit, and it only errors when there is more than one user using the front end system. When I'm using it solely, no errors at all.

 

[Banana]

And are your user viewing the exact same record?

Does it error even if they are not viewing the same record?

 

[Adzi]

It errors whenever two people are accessing the database.

If one person is creating a new record, and someone is just looking at the main menu form, then the system will produce a 2501 error.

 

[Banana]

If the main menu form isn't displaying the record that was being edited at all, then I think there is something else going on.

1) How is your database split? Are there any non-linked table?

2) Does each user have their own private copy of front-end?

3) Where is the backend located? Is anyone opening it?