Question How to share DB?

[librag]

Very simple yet has become an issue with my new problem!

I created the DB in 2000 version. Unsure if it had anything to do with the fact that I started creating it on laptop then created the rest on another computer. At the moment I can not update (create any Macro's reports or anything) if someone else is using the DB simultaneously. I am keep getting an error msg as follow:
" You do not have exclusive access to the Database at this time. If you proceed to make changes, you may not be able to save them later."

The ONLY way I can modify the DB if everyone is out of the DB and ONLY I am in it making the changes, sort of defeats the purpose of using DB!

I have checked under Tools, Option and Advanced Tab on the menu bar - its marked Shared. The properties for the DB (when closed), I have adding all employee's names so they can have Read and Write access - but NOT the full access.

Why is DB not allowing me make any edits, while everyone is it?

Thank in advance.

Gini

 

[boblarson]

You cannot make changes while someone is in the database; PERIOD.

So, what you need to do for shared database use is

1. Split the database so that there is a backend (tables only) which resides on a shared server and a frontend (everything but the tables) and that resides as a COPY on EACH USER'S MACHINE.

2. You keep a master of the frontend and you do your development work there and then when you have the changes made you release a copy of it and deploy to the users. If you don't want to do that manually each time (deploy that is) then you can use an auto updater. I have a Frontend Auto Update Enabling Tool on my website (see my signature and then go to Free Access Tools) or you can use Tony Toews' at http://autofeupdater.com/)

So then the only time you need everyone out of the database is when you need to make a change to the backend tables (and if you have designed your database properly - i.e. properly normalized, that should be a RARE occasion).

 

[librag]

OMG - Oh dear now I really feel silly for not knowing abt making the changes in the DB while in use!

That is what I get for keep honoring requests that are coming in after its delivered!

Thanks much!!!!

Gini