Can not run Macro when logoff the Server

[katekaew]

I created a button on a form ("Form1") in Access2000 using VBA.
Normally, when I want to run the Queries I have to press this button.
Now, I want to make it automatic and no need to press the button and run daily on the NT server.
The step is:
1. Create macro("Macro1") use OpenForm, point to "Form1"
2. Create batch file to call "Macro1"
3. Set the Schedule task on NT Server to activate "Macro1"

Having done all these, the daily script update run perfectly.
But the problem is that I can not logoff from the Server. I have to leave the Desktop/Screen open.

How to solve this problem? Please advise!

Thank you so much.

 

[Jings00]

I say welcome another member to the "user become corporate IT policy abuser" club.

I beleive there is no solution to this.

If you reside in a corporate environment like myself and many others here, you can either leave your system on "locked" and become a mini IT administration server for your databases, or you can ask IT very nicely for their co-operation in setting up your macro to run on their system for you.

I problem I always encounter -and I think there is some greek axiom named for it...is that IT will very quickly tell you to shut-down the self running macro since it is a process outside their control, but will tell you resources are available to set the macro up for you in about 2 years.

Best bet - set up a machine in your department that runs all the time and will do all the automated tasks for you, but DON'T tell the IT department.

PS - my luck would have someone from my IT dept reading this..

 

[RV]

Apparantly, you've got a split database (backend and frontend).
That's the reason you'll have to keep your desktop open as your queries are held in the frontend, not "the IT department" as per Jings00's out of date remarks.....

Consider placing a copy of your frontend on the server.
Make any required changes to your macro as for the new location of your frontend.
This way, it's only the server that needs to be up and running.

RV

 

[Jings00]

I am confused as to the actual question.. and RV's solution

If the question is how do you automate a database activity, I understood that in order to do that you need to 1)create some form of automated event to 2)actually run the database somewhere.

If the automated event resides on your desktop, then I am assuming the desktop needs to be logged in for the event to occur..so the front end/back end or whatever will open on your desktop and perform the macro.

We are doing this quite alot here, and I have not heard of any other way of automating a database action without someone somewhere opening the database.

Again, if the original poster was asking something else, I am sorry ... and I am also appologize for any blatant IT dept bashing.

RV, I don't understand how having the front end on the server will make any difference. We have a automation database here that performs all the automated tasks at 5:00am, and we CAN'T have it on the server since we need to leave it running and the server back-up routine that happens overnight will cause a disconnection.

 

[RV]

We are doing this quite alot here, and I have not heard of any other way of automating a database action without someone somewhere opening the database.

Just a thought,

putting a frontend on the server would mean you wouldn't need to keep running your applic on an active desktop.
You could perform all your "automations" on the server.
Which would solve the original problem:

But the problem is that I can not logoff from the Server. I have to leave the Desktop/Screen open.

RV

 

[Jings00]

RV, I absolutely agree that the ultimate solution to the automation issue would be to have the server do all of it. Infortunately for us, server automations are administered 100% by IT and they have bigger issues to deal with right now (like SOX compliance ). Which leads us right back to the deal with it yourself solution, and the constantly running desktop with amazing user rights sitting empty and logged on(but locked) all the time. IT would have a fit (and I have seen it since the Ap Eng group got caught doing the exactly same thing) if they knew what we were doing.

 

[RV]

server automations are administered 100% by IT

Jings00,

we're not talking 'bout server automation here.
We're trying to find a solution for what seems to be a rather "easy to fix" issue.
IT won't be supporting Acces databases anyway so what's the problem for them

Apparantly, I pushed one of your red buttons

Fortunalety, the times that IT departments were allmighty have long since gone.
Nowadays, there are expected to be business focused instead of teggie focused.
My experience is that whenever you can up with a good reason, they will / must help you.
Anyway, that's always works for me.

RV

 

[katekaew]

Thanks for all answers and opinions! The fact is that my computer doesn't have a schedule task menu. I can not do it on my PC, neither my collegues. What I can do now is to run the script the first thing in the morning and keep trying to find another ways to make it works!
Thanks again!