Web Development

Ask something
Discussion Locked

MS Acces to be shared

0 helpful
7 replies

by bobby

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to have a database shared between two users - they are running windows 2000 server and 200o pro. How can this be done so both have access to the same table simultaneasly? i know that updating records might cause conflicts but i don't think that updating will take place at the same time.

7 replies

by sl-campbell

There are no real problems with this unless the users are modiying the same record at the same time.

You need to make sure that the users have permissions to edit the objects, (usually this is the default), and that any database or recordset objects in code are opened for shared usage, and that the standard open mode option in MSAccess is set to shared usage (also default).

What exact problems are you having?

by sl-campbell

Donq is right. I guess I read it too fast and didn't see that the problem was more basic.
However I would suggest not using the database splitter if you have alot of tables.
I would open an empty database and import the tables from the original and then move this to the server. Then in the original I would delete all tables and then link all the tables from the new mdb which is on the server via 'File / External Data / Link Tables' (or whatever it is on the english version). Do this for the 2nd workplace also, or copy the linked MDB and refresh the links.

With the splitter, when the number of tables reach a certain amount (with my experience somewhere between 80 and 110) the linking information is not always 100% correct. You will notalways experience a problem (and maybe not even via Access but thru another program when accessing the linked tables- such as Crystal Reports).

On MDBs with a small number of tables I never saw a problem using the splitter, and manually creating the links I never had a problem no matter what.

by donq

You MUST split the .mdb file into two parts and this can be done using the Database Splitter under the Tools menu (Tools | Database Utilitues | Database Splitter) or it can be done manually copying each Table into a new Database located on the server, then deleting every table from the PC original and linking to the server based Tables. (the Linked Table Manager is the Wizard immediately above the Database Splitter Wizard). Very easy to do but do from a back-up until you get the hang of everything - good luck.

This discussion is closed to new replies.