Duplicating a table

[Keith Burgess]

Hi There,

I am trying to copy a table and put the copy in a folder called "My Data Sources". The reason being when I set up a mail merge letter it defaults to "My Data Sorces" for the recipient data. I also need the second table to be updated every time we enter data in the original table.Has anyone got any ideas please????

Best Regards
Keith

 

[Dennisk]

you can only copy an access table within access.
But you can Export a table to another db
However what you require is a shared database. Only one copy of the table in the only copy of the database.

For your mailmerge problem just change the default path.