Running VB Script

[DC CS]

Hi all,


I have a VB Script running once a week to generate a report of incomplete processing in my Access database. The script code as follows:

Set accessApp = CreateObject("Access.Application")accessApp.OpenCurrentDataBase "C:\Users\AppData\StudentAdmin\Student Admin.accdb", false
accessApp.visible = true
accessApp.UserControl = true
accessApp.DoCmd.RunMacro "Macro1"
accessapp.quit

The issue is that the script runs fine, but it stops at the login screen and I need to enter the cridentilas before the rest of the script is executed, with the resukt that it neverruns as the cridentials are not entered.

Is there a way to bypass the login username and password to execute the Macro1 only?

I am new at VB scripts and found the above code sample for the VB script on Microsoft's web site.

Thanks

[Minty]

Could you not create a simple Autorun database that produced the report only then closed down?
If it's on a server that's on 24/7 then no-one else is likely to get to it?

[Micron]

Not clear but I suspect the login is in the called db. If you can use a desktop shortcut to launch the called db you can pass a command line switch contained in the shortcut to the Cmd function written in code in the called db. That function will return the switch if it exists. If it exists, then code your called db so that it bypasses the login part. As long as a regular user cannot access the shortcut they will have to log in.

[DC CS]

Hi all. Sorry for the delay. The Autorun db did the trick.
Thanks