-
March 25th, 2008, 02:42 AM
#1
Scheduling an Access program
I have an Access 2002 program which requires user to enter user name and password to log in. After successful logging in, a menu displays and user will select an operation, such as data entry, generate report etc from a menu.
Is it possible to set up a schedule task such that the program will run as a pre-approved user logged in and start a pre-set operation?
Thanks for your advice.
-
March 25th, 2008, 06:12 AM
#2
You may be able to schedule a VBScript or an AutoIT script (my preference) to pass username and password to the database.
-
March 25th, 2008, 12:13 PM
#3
Thanks smurfy for the advice. Could you give me some more idea or information (e.g. some sample script etc). Thanks a lot.
-
April 2nd, 2008, 06:36 PM
#4
I found somewhere that I can use Windows' scheduler to pass access.exe /username /password command. However, I haven't tried that as I think it may not be after to pass the name and password to the custom made log in interface which will read these data into 2 string variables for authentication.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|