Updating Databases

  • Thread starter Thread starter JoeCL
  • Start date Start date
J

JoeCL

Hello!

I have this situation where I gave a copy of the database
to the use so she can enter data while I am developing
forms/queries, etc. on my copy. How can I update my copy
of the tables with what the user entered on her copy of
the database. Like synchronizing both databases. Thanks.
 
You split the database into 2 files.
1. Back End .mdb (only has tables)
2. Front End .mdb (has linked tables to BE and all queries, forms, reports,
code, etc)

Then you can send a new FE to the user who re-links the tables and contiues
to work.

See http://www.mvps.org/access/
for code on how to re-link tables automatically.

See http://www.granite.ab.ca/access/autofe.htm
for a small program to automatically update the FE each time it runs.
(Makes distributing a new FE to many users as easy as dropping it on a
network shared folder.)
 
Hello!

I have this situation where I gave a copy of the database
to the use so she can enter data while I am developing
forms/queries, etc. on my copy. How can I update my copy
of the tables with what the user entered on her copy of
the database. Like synchronizing both databases. Thanks.
Click to expand...

This can be pretty easy - just use File... Get External Data... Import
to import from the second database into yours; or it can be almost
nightmarishly difficult, if you have both been adding records to
tables which have Autonumbers. You will have added a record with 327
as its autonumber primary key; she will have added a DIFFERENT record
with 327 as its primary key. And that key may be reflected in one or
more related tables.

The answer is - *it depends*. How are your tables structured?

The preferable approach here is to have THREE .mdb fields: use the
Database Splitter Wizard to split the tables into one .mdb file, and
all the forms, reports, queries etc. into a different one. Make two
copies of this "frontend", both linked to the tables in the backend
over the network (if you have a network... :-{( ). Give your coworker
one frontend to enter data, you use a different frontend for design
changes; when you have the new upgraded frontend, simply delete hers
(there's no data in it after all!) and give her the latest & greatest.
 
Back
Top