Appending to Linked Table (Access 97)

Topic

New Reply

Transcripts.mdb contains table CompletedCourses. Marks.mdb links to this table. Info from a query in Marks is to be appended to the table in Transcripts. Should the “destination database” property of the query be ‘Current,’ or should it contain the filepath to Transcripts? This previously worked using the latter method, but since then, both databases have been moved to a different location. The linked tables work properly, but the append query gives a message: cannot find file I: Academic etc , even though the file path and name shown are correct.
Thanks, Betty

Reply | Quote

Replies

if this is going over a network i would use universal pathing
server name folder name filename
instead of a drive letter
especially if more than one computer is going to use the database

Reply | Quote

I can’t figure out what you’re tyring to do. You have a Transcripts database and a Marks database. CompletedCourses is a table in Transcripts and Marks has a link to that table. You want to run an append query in Marks to add data to the CompletedCourses table. Is that right so far?

If it is, then you don’t have to worry about the destination database. You are appending to the linked copy of CompletedCourses, which automatically adds the records even though you have told it to use the current database. The current database is where your active link to CompletedCourses lives, so that’s where your query needs to run. You’re making unnecessary work for yourself appending directly to the source database..

Reply | Quote

Thanks so much. This is so obvious in retrospect. This was my first db with linked tables, and I have no idea why I set it up with a Destination db in the first place. It works perfectly now.
/Betty

Reply | Quote