Running a macro with a script

[Chuck W]

Hi,

I created a macro in Access that will run several large
queries and create tables. I want to run it every
night. I talked to the Network Administrator who said
that he could right a macro to do this. However I also
coded this so that users cannot get to the tables and
queries to mess things up. You can only do this if you
double click the application with the shift key held
down. The Network admin said he didn't know how to write
a script given this setup. Can anyone give me advice on
how to run this macro?

Thanks,

Chuck

 

[Steve Schapel]

Chuck,

There shouldn't be any problem here,... unless I am misunderstanding
you. There is no need for anyone to "get to" the tables or queries.
All you need is the macro set up correctly to run what I presume are
Make-Table Queries, using OpenQuery or RunSQL macro actions. And then
your network administrator can set up a scheduled task to run this
macro, which would, if he is using Windows Task Manager, use a command
line something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x NameOfMacro
If I have missed what the actual problem is, maybe you can post back
with full details of the macro you are trying to run.