exporting selected records to another database

[Guest]

access 2003: we have a project whereby a master database is contantly being
updated. We need to regularly send the updated records to several duplicate
databases. This is a music database with each host computer having its own
hyperlinks to files. This makes simply copying the whole database no good as
we lose all hyperlinks. I want to be able to isolate new records as a batch
and send to others to import so the add on to the database in sequence, ie
record numbers will stay the same. Thanks

 

[pietlinden]

access 2003: we have a project whereby a master database is contantly being
updated. We need to regularly send the updated records to several duplicate
databases. This is a music database with each host computer having its own
hyperlinks to files. This makes simply copying the whole database no good as
we lose all hyperlinks. I want to be able to isolate new records as a batch
and send to others to import so the add on to the database in sequence, ie
record numbers will stay the same. Thanks

Are these local databases? If you store the relative path to the
sound files as text, you're good to go. You can use App.Path or
CurrentProject.Path to get the directory and append subfolder info
from there.

 

[Guest]

Thanks for that but a bit beyond me!. It is the method of creating exportable
records that I need to get sorted mostly, I can sort out hyperlink
later.Cheers
David

 

[pietlinden]

Thanks for that but a bit beyond me!. It is the method of creating exportable
records that I need to get sorted mostly, I can sort out hyperlink
later.Cheers
David

you can just create a normal query and then append to a linked table.