Syd2008
asked on
Macro ---Run Command
In my Access db I created 2 querys delete_table1_query and Append_table1_query I want to run this querys through macro --->open query----->delete and append query but its taking a long time to run this macro so how can I call my delete and append querys through RunCommand in macro ? I am not too familiar with VB Script so I would like to stick with macro
Note:above is just an example,in real there are total 12 delete and Append query and this Access db is sitting on a network drive.
Note:above is just an example,in real there are total 12 delete and Append query and this Access db is sitting on a network drive.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Before going down that route force the opening of the database on the so it is exclusive adn see if it makes a difference. The easiest way is through teh File Open dialog and the Open is a drop down.
Cheers, Andrew
Cheers, Andrew
ASKER
<<opening of the database on the so it is exclusive adn >> I dint get that can you please explain me what you are tring to say ?
<<File Open dialog and the Open is a drop down> ??
<<File Open dialog and the Open is a drop down> ??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Syd2008, has this resolved the issue?
Cheers Andrew
Cheers Andrew
ASKER
I run the Macro(delete and append querys) in my local drive and its taking no more then 2 min where as in network drive the same macro is taking 15-20 min.
Scope, I want to make a copy of the 6 link tables coming from the production data so for example: Link table name: employee I created a UAT database in network drive and created a table called employee_copy so every day when we get new data I am first deleting current data from employee_copy and then append latest data from employee (link table which is coming from the production data)
Any easy way out ?