If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Multiple Users Enviroment
Thanks guys. I will try the way you guys said.
"John Vinson" wrote: On Wed, 19 Oct 2005 08:00:04 -0700, "AccessHelp" wrote: If I just have a copy of database in a shared drive, only one user will be able to use it. That statement is *simply incorrect*. Access is a multiuser database environment, out of the box. "Splitting" is a good idea - it means that you should have one database file containing the Tables, on a shared drive; each user should have their own copy of the "frontend" containing the forms, reports, etc. with links to the tables in the backend. Database Replication is complex and rather hard to manage, and is not appropriate for this situation. It's needed when you have users who are not sharing a network (say one user at the office and another traveller using the database on a laptop); it lets you keep two backends (containing, again, just the tables) synchronized. If all your users have access to the shared backend over a reasonably fast, stable LAN then replication is just a lot of extra work for no benefit. See http://www.granite.ab.ca/access/splitapp/index.htm for a thorough overview of the database splitting issue. John W. Vinson[MVP] |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to allow multiple users to update workbook (on network)? | quddusaliquddus | General Discussion | 0 | June 29th, 2005 07:33 PM |
Multiple Users Deleting records from the same table | DaveK | Database Design | 6 | June 7th, 2005 09:56 PM |
Setting up forms for multiple users | bgarey | General Discussion | 1 | May 30th, 2005 08:01 PM |
I want users to be able to select multiple items from a single co. | Basani Maria | Using Forms | 1 | September 13th, 2004 01:15 AM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |