Appending to Another Database in Another Folder

[Dukelewis]

I am attempting to use an append query to append data to a table in another database. The database is in another folder on my network. The problem is that Access automatically assumes which folder I'm attempting to append to. For instance, the table I want to append to is located in g:corp\premium data storage.mdb. The append query is located in g:corp\company1\premiums.mdb. Whenever I run the query Access automatically assumes that the database I'm going to append to is located in the company1 folder. Thus, I receive an error message and the query fails. I would like to move the files into the same folder but the databases must remain in their current folders. What can I do to fix this? Any suggestions would be appreciated! Thanks!

[This message has been edited by Dukelewis (edited 03-28-2002).]

 

[DJN]

If you use the TransferDatabase method, the path to the destination table has to be specified. TransferDatabase can be used for queries.


David

 

[edtab]

You can try linking your target table to the database containing your append query.
Once you link your table, its as if that table resides in the same database where your append query resides.

To link tables, open your application and hit F11 to get your objects (ie. tables, queries, modules, etc.). Choose tables then click File, Get External Data, then Link Tables. When you do this a window will open up where you can search for your target table residing in another databse somewhere in your system.

Try this and let me know what happens.



[This message has been edited by edtab (edited 03-31-2002).]

 

[Dukelewis]

Thanks for the advice! I'll try both suggestions and see what happens.