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

[Guest]

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??

 

[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.

 

[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.

 

[Guest]

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
__________________________________________

 

[David W. Fenton]

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??

Others have explained how to do this on a LAN, but it's also
possible to use Jet Replication in situations where you don't have a
LAN, but need to have two people editing your data at the same time.
That's obviously not your situation so not applicable to you, but I
think it's helpful to have the possibility raised for others who
encounter this thread in the Google Groups archives.

One point: a replicated app, just like an on-replicated app, needs
to be split, though it's even more crucial with replication, as Jet
replication causes real problems when used on front-end objects. Put
another way, replication should *never* be used on a front end --
only ever on data tables (though it's also completely safe for
queries, which like tables, are pure-Jet objects).