I have been asked to create an Access database at work for a confidential function. I'll call it DB1
This database will be placed on a server with the necessary security.
All of the necessary data is already entered each day into another Access database which is on the same server. I''ll call this one DB2
What I need to do is inport one table from DB2 into DB1 each day, then run an Appnd Query into my DB2 table, then delete the imported table.
I can do all of this manually, but I won't be there every day (vacation, sick etc.) As a result I require an automated procedure to do this.
I really have no idea where to start. All suggestions to bring this about will be greatly appreciated.
This database will be placed on a server with the necessary security.
All of the necessary data is already entered each day into another Access database which is on the same server. I''ll call this one DB2
What I need to do is inport one table from DB2 into DB1 each day, then run an Appnd Query into my DB2 table, then delete the imported table.
I can do all of this manually, but I won't be there every day (vacation, sick etc.) As a result I require an automated procedure to do this.
I really have no idea where to start. All suggestions to bring this about will be greatly appreciated.