Copying tables

[Guest]

Dear Sirs
I have two Access databases where I copy a table from one to the other
database on the same computer.
The purpose of this is that I need the target database (which is much
smaller than the source database) on my lap-top for marketing purposes.
So, as long as I have the target database table on my computer (where as
well the source database is) everything is fine and I can see the data. As
soon as I transfer the target database to my lap-top all data is gone.
How can I avoid this?

 

[Jeff Boyce]

If you "link" from your laptop to the desktop tables, you can run append
and/or update queries against the data in the desktop system, to update the
tables in the laptop system.

When your laptop is not connected to your desktop, the links won't work (but
then, you would have already copied the data you need into your laptop
tables, right?!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff
You are correct, when my laptop is not connected to my desktop, the links
won't work, but the data which was transferred before, is gone as well - that
is my problem and I don't know how to solve that.
In short, as soon as I have the base on my Laptop my tables are emtpy.
Any idea why and how I can avoid that?
Regards
Klaus

 

[Jeff Boyce]

If the data is gone, then there's a very good chance the data hasn't
actually copied over. I suspect the link, not the actual data, is what's
being seen.

Regards

Jeff Boyce
Microsoft Office/Access MVP