Hi Rob,

1. If your table contains one or more relationships, go to Step 2. If not
go to Step 3.
2. Open the relationship window and delete all relationships in your
table.
3. Create a new database.
4. Open the new database and use File-Get External Data-Import to import
your table.
5. Send an email to the other users and attach the new database.


For the other users .........
1. Save the attached new database in the email from you.
2. Open their database.
3. If their table contains one or more relationships, go to Step 4. If
not go to Step 5.
4. Open the relationship window and delete all relationships in their
table.
5. Use File-Get External Data-Import to import the table in the database
you sent them
6. If their table contains one or more relationships, go to Step 7. If
not Close everything; they're done.
7. Recreate the relationships in the new table.

Steve




"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