Function to import a query as a Table
Posted on 2008-06-11
I have an Access Database that uses a snapshot query for ad hoc reports. I do not want this user going into the Production Database to create new queries against this Query. I know you can import a query as a Table. How can I through a Function import a query as a Table from another database and replace the existing Table automatically.
Example the Table in my reporting database that comes from another database's query is named MainRecords_Snapshot.
The query in the database H:\Trucking\2007_SubmissionLog\Database\061008_Trucking_Submission_Log_NewChanges.mdb is named MainRecords_Snapshot
I run the function and it imports the query MainRecords_Snapshot from H:\Trucking\2007_SubmissionLog\Database\061008_Trucking_Submission_Log_NewChanges.mdb and replaces the Table MainRecords_Snapshot without prompts in my reporting database.
How can I do this? Thanks