I want to edit a database on two different computers at the same t

D

DavidC

I want to edit a database on two different computers at the same time. I am
not using a "server". I am on a lan. I need to do this in Acess 2007. How??
 
D

Douglas J. Steele

Split the application into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relationships).

Put a copy of the front-end on each computer.

Put the back-end in a shared folder on one of the machines, and make sure
all users have at least Read, Write, Execute and Delete permission on that
folder.

Make sure that the front-ends are linked to the back-end using a UNC
(\\computer\share\folder\file.mdb) rather than a mapped drive letter.
 
A

Arvin Meyer [MVP]

If you are using a peer-to-peer network, one of the machines will be
required to act as a server. Almost all LANs do use a server though.

In either case you need to split your database and put the tables in a spot
on the machine which will do the sharing (server). Attach the tables to a
copy of the front-end running on the same machine if peer-to-peer, or on the
server. A separate copy of the front-end is put on the second machine and
enabling file sharing, you will attach it to the back-end (tables) running
on the first machine. Peer-to-peer machines running this way tend to slow
down, which is why another machine (3rd machine) may be used as a server,
even it's not a true server.

Never share an unsplit database. It will eventually corrupt. Splitting is
easy. There is a wizard to walk you through it. Look in Tools >>> Database
Utilities >>> Database Splitter.
 
T

Tom Wickerath

Hi David,

As Doug and Arvin have mentioned, you should split the database into a
front-end (FE) and back-end (BE) first. Here are a couple of links where you
can read up more on the benefits of splitting:

Split the database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB
http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

For Vista, make absolutely sure that you install a hotfix that is available.
See the second yellow box on Allen Browne's web site "WARNING: Windows Vista
bugs":

http://allenbrowne.com/tips.html

You may also find this article useful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top