need to share data in A97 & 2002

K

kim

,Hi
I have a database I use at work on Access 2002.
I have to work outside the office at other locations using my laptop which
has Access 97, and I need to put new data into the database via this laptop
when I work away.

I then need to get this new data into the 2002 database at work when I get
back to the office.
It is not an option to put 2002 on to the laptop.
There is a copy of the database on the laptop and a converted (TO 2002)copy
on the work computer
Could anyone please suggest a way to do the above tasks?
Thank You
 
A

Allen Browne

Split the database so you have two mdb files. The back end contains only the
tables; the other contains all other objects (queries, forms, reports,
code), and linked tables. The back end must be in A97 format. You will have
two front ends: one in A97 format, and one in A2002.

Now you can copy just the back end file to and from the target location, and
use it wherever you wish.

The A2002 front end has no problem linking to the A97 back end. Just make
sure the A2002 front end has this box unchecked:
Tools | Options | Advanced | Open databases using record level locking.
 
K

kim

Thanks you, I see the point but I am missing something here : Iwill have the
97 back end on the laptop; enter say, 50 new records at the remote location.
I will then need to incorporate these new records into the copy of the
backend on the work 2002 PC.
I tried get external data > import but this makes a copy of the table.
This means lots of deleting and re naming
Is there a way to append just the new records to the table on the work PC ?
Thanks for your help.
 
A

Allen Browne

If only one copy is being updated at any one time (e.g. laptop only on
weekends), you could just copy the back end file onto the laptop, modify the
database over the weekend, and then copy it back to the main network machine
on Monday morning before anyone else modifies the data there.

If you actually need to have the data modified in different locations
simultaneously, you could look at replication. It's not all that simple,
though, so use this only if you really need to.
 
Top