Jeff,

We're not on a network but standalone computers and spread across the
country so difficult to get everyone together.

I've searched for info on copying a table but nothing seems to be
straightforward.

Ta, Rob


"Jeff Boyce" wrote in message
...
Rob

I'm not clear on your design, based on your description.

It sounds like you have yourself and 6 users, all of whom have their own
copies of a single database.

Any chance all of you are on the same Local Area Network? If so, look
into using a "split" design, rather than independent copies of the db.
Post back here if "split" is unfamiliar...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Rob" wrote in message
...
Hi,

Using Access 2000. I have a fairly simple database which is updated with
data weekly through an import routine, however, one table in the database
needs to be updated with some new records which isn't included in the
weekly update. I could speak to the 6 other users which all use a copy
of the database to talk them through the changes needed but they aren't
very experienced with 'behind the scene' workings.

My ideal would be to export my table that I update and have them import
the table into their database and thus, overwrite their original table.
I looked at sending them the whole database less the data but they can
and have created their own queries which would be lost.

Is there a way to copy and replace a table in another database?

Thank you, Rob