How to give access for my database to all the users

[Buj123]

I have bulted a Access Database, now when all the users open it up its not allowing any body to save thier changes. Its giving a message saying

"You don't have exclusive access to this database, if you try to save the changes, you will no longer be can use it"

Please help me out how to solve this so that all users can access it at same time.

 

[tracy1234]

Try tools/options -> advanced tab. Set the Default open mode to shared.

-Tracy

 

[Buj123]

it is in shared mode, still when all users are trying to save their changes its not allowing them to save. I am very frustated about this. Do we need to uncheck the
Tools->Options->Advanced-> OpenDatabase using RecordLevel Locking

 

[tracy1234]

No, we use record level locking and this does not produce the message you are seeing. What kinds of changes are the users making?

-Tracy

 

[Glohamar]

I would leave the Record Level Locking checked. I do not think that is the problem. Try opening the database yourself and verify that you can save records, then have only one other person open the database while you have it open and see if the problem still exsits. It almost sounds like someone is opening the database Exclusively.

Dave

 

[Buj123]

Actually i have tried to doing that opening on my PC and opening on some other PC, sometimes on some PC its working and on some its not working. Is it possible that my database can be opened Exclusively on some other persons pc (because its in Shared in my PC)

 

[tracy1234]

Check to see if someone is using the design mode while other users are in. Also, we found that if a person is exporting data to excel, the message you see can be generated.

Good luck. Heading out for the weekend.

-Tracy

 

[Buj123]

Let me check that out with some of the analysts, and i will reply back on tommorrow. It will be great if any one can check this post tommorrow too. Thanks.

 

[Glohamar]

I am searching Microsoft Knowledge base and found this. Do not know if it applies to you, but worth a try...

http://support.microsoft.com/default.aspx?scid=kb;en-us;297030&Product=acc2000

I will keep looking. It will be tomorrow before I can respond, I am leaving work for the day.

Dave

 

[cghoga]

If you haven't already, try splitting your database into a front end and back end. Store your data tables in the backend. Give each user a front end GUI containing all your forms, queries, etc. In the front end you will need to make sure your tables are linked to the back end. If you use the database splitter (Tools - Database Utilities - Database Splitter) it should walk you through this step. (If you manually link, in table design view, right click, choose Link Tables.....)

Hope this helps you.