Record Locking

[D-Fresh]

Okay, I have a form that reads off of a query. My database is shared and on a network drive. Everytime more than one person is in the database, you can't save a record you just inputted into the form. I get the 3260 Error, the Locked by another user error.

Even if both people are not in the form, it still gives that error. I've been doing a little research and it seems like I have to use Optimistic Locking, or something like that. Could anyone tell me how to insert that into my code. I have a button that, when pressed, opens up the form. If there is something I could do here, that would be great. An even better solution would be if I could somehow put it for all records in my AutoExec macro. Thanks.

Doug

 

[StephenS]

I am going to assume that you are using Access 2000. Before you go to the VBA/code level, you might want to see what your global multiuser settings are. Choose Tools|Options, and then click the Advanced tab. A dialog box appears that gives multiuser settings for record locking. They are: Default Record Locking, Record-level Locking, Default Open Mode, Number of Update Retrties, ODBC Refresh Interval, Refresh Interval, and Update Retry Interval.

Although Record-Level locking is probably what you want, you may want to see what Help says about each of them and play with them to see how they work.

StephenS

 

[D-Fresh]

I'm sorry, it was my fault not to specify. I am using Access 97. I tried the options in the tools->Options->Advanced, and nothing came of it. If anyone can help, please let me know. Thanks

Doug