Databse/Record Locks

[BBDC]

Good Afternoon All-

I have a database that will be on a server accessible to several users. I intended the forms in the database to allow said users to edit/maintain the data at the same time (with the exception of the same record). However, anytime a user opens the database, it is placing a .ldb file in the folder and allowing the other users read only access(i.e. it lets someone enter data in the form, but when they try and save or navigate to the next record, it is displaying the following:

[Database Name] cant save design changes or save to a new database object because another user has the file open. To save your design changes or to save to a new object, you must have exclusice access to the file/"

Any thoughts? The ideal functionality is as follows:
Users can access maintain all data in the database with the exception of if a 2 users try and edit the same record.

Any help would, as always be much appreciated.

Best,

BBDC

 

[danvlas]

Tools-Options-Advanced
Default Open Mode = Shared

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[BBDC]

Thanks, I just verified that this setting is flagged, and it was. According to Tools>options>advanced:

Default Open Mode =Shared
Default Record locking = No Locks

Database still has a lock file being placed on it....any thoughts?

 

[dhookom]

All users must have create and delete permissions in the folder containing your tables MDB. Your error message suggests the issue is with users attempting to save the form and not the records.

Is there any code running in the form(s)?

Are users clicking any "Save" commands?

If multiple users open the MDB without opening any forms, can they all edit records in tables directly?


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[BBDC]

Thanks for the response time,

the database is structured as follows (it is all forms that update tables in the back end...there isnt a whole lot of security surronding the form, but a user could enter data directly in the tables if they new what they were doing)

On database start there is a query screen which either allows users to search/run reports, or take them into a record maintenance form

The record maintenance form has some code running in it, specifically the following:

on click of "exit button", code validates certain pieces of required data exist on the form

On timer code used with the below piece of code:

code to check if a record has been an edited...if yes display a restore entry button which functions the same as a user doing ctrl-X

The only save command being used is the generic save icon on the access toolbar

Thanks for the help!!!

-BBDC

 

[straybullet]

In addition to create and delete, your users need modify permission to the Windows folder that houses the database on the server. This will allow them to "join in" on the already created ldb.

Let them hate - so long as they fear... Lucius Accius

 

[dhookom]

I expect the "generic save icon on the access toolbar" is attempting to save the form design rather than the record. Records are saved automatically. If you want to provide a manual save, they would need to select Edit... from the menu.

Also, as straybullet suggested, all users must have near complete permissions in the folder containing both the front-end and back-end mdbs. This includes the permission to create and delete files.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]