Sharing a database

[limperger]

Hello everybody:

At my workplace, there is a Access database that is shared between 3 users. We are currently experiencing some problems with the sharing. Let me explain it: I have set the sharing properties (at tools>options) as Database status = Shared (not exclusive) and entry-locked, as well the other lock at record-level. Additionally, I have set an entry lock (record level) in the form properties. Nevertheless, we have a bit of a problem here since when one particular user is working with the form, a second user is not able to work with the form. The entire form, then, seems to be locked as no changes are possible, not only in the record currently changed by the first user, but also the rest of them.
Any ideas of why is this happening?

Thank you very much in advance

Best regards from Barcelona

[anvidc]

You may do it in this way.
1. Assume you have a Database on server
2. Create a New Access and Link table to the Server Database
3. Copy the New Access to All the user

or

u can just Split your Database at tools-> Database Utilities -> Database Splitter

so u have front end program and back end database

[limperger]

You may do it in this way.
1. Assume you have a Database on server
2. Create a New Access and Link table to the Server Database
3. Copy the New Access to All the user

or

u can just Split your Database at tools-> Database Utilities -> Database Splitter

so u have front end program and back end database

Thank you very much for youre response. I will try to do what you state in the first place since the database splitter option is disabled in the 97 Access that we have installed here, as well as other useful options...

Best regards