Importing exporting data

[hinser13]

I have two databases.

1: one Stored on shared drive and accessed by multiple users

2: 2nd Stored on Tablet PC Cdrive for field use

I intend to use an append qry to to export data back into the main database following site visits and this is not a problem.

The problem is:
What is the best way to get the data out of the multi user tables into the tablet PC.

Cant use an append query as the 2ND Database is stored on the tablets Cdrive. If I write a query and choose append to another database, you cant, as I wont be abale to view the tablets c drive from the database stored on the shared drive!

 

[PaulO]

I'd consider using a memory stick as an intermediary database and write queries into the master database to interchange data between the two data sources.