Linking/Merging/Replicating an Access DB

[Guest]

I do not know what to call it, but I have a simple access database (mdb) on
one computer that I want to be accessable from another to where both pcs can
be adding/editing information at the same time without overwriting what the
other is doing. The information is very linear and I did not create the
database so I would need help to know what info is needed if more info is
needed.

Thanks

 

[David W. Fenton]

I do not know what to call it, but I have a simple access database
(mdb) on one computer that I want to be accessable from another to
where both pcs can be adding/editing information at the same time
without overwriting what the other is doing. The information is
very linear and I did not create the database so I would need help
to know what info is needed if more info is needed.

1. Split the database into front end (forms/reports/etc.) and back
end (tables only). There is a database splitter wizard to do this
for you.

2. give each user a copy of the front end.

3. there is no step 3.

Access is by default multi-user, but it has certain issues with
sharing front ends that are overcome by splitting and giving each
user a front end.

All the above assumes that all the users are on the same LAN. If
they are not, it won't work. There are other solutions to that
problem (all much more complicated), but I won't bother to detail
those until it's clear they are needed.