Multiple Users, One database

[Dominate007]

The company i work in has one database for all the products that come in. therefore there are more than one users on the same database, when it starts it says that i dont have exclusive rights to the database and that i wont be able to save my work. how do i change it so that all of us can logto the database at the same time and save it

Thanks

 

[mp9]

In A2002: Tools, Options, Advanced - select default open mode as Shared rather than Exclusive.

Also, if your db is secured at a user-level (i.e. each user logs on with their own db username and pwd) you can set security so that users or whole user groups don't have the priv's to open the db exclusively.

HTH.

http://www22.brinkster.com/accessory/

 

[lupins46]

Access does not allow design changes to a shared database unless it is opened by the designer first (then no-one else can get in).
If you want to make design changes you have to work on a copy. You should look at the database splitter tool and the linked tables manager on the Database utilities menu.

 

[Scoob55k]

On this issue, we're having a problem where the database was created in Access 2003 and when worked in the same office, it shared fine. Once directions to the link were distibuted and users created a link to the shared database on the network on their desktops, the recieved the "Exclusive Rights" message.

The only way they have gotten it to work is by using the splitting tool and split the database of which sounds pretty cool, but I am not so familiar with. Thanks!