Hi All,
I need some help on copying one table from a database to another database at a different location (not a linked table).
All of our data entry users have access to two drives:
G drive and O drive
The G drive holds the data entry and management database called "RequestDatabase" in which the data is written to a table called 'Master'
The O drive will hold the master table data for management to run reports and should have a portable copy of the 'Master' table and not linked to it called "ReportDatabase".
Management have access to the O drive only.
How do I have our data entry database execute a command to copy over the Master table from the RequestDatabase over to the ReportDatabase.
Before anyone suggests a linked table, this won't work as management don't have access to the drive the requestdatabase is stored for security reasons.
Help Help Help is much appreciated :-)