Kicker
03-31-2010, 08:08 PM
At work, we have several very large network servers that store several thousand oracle tables each. Each has its own login/password combination.
Here is the problem. I have several Access applications that use many of the tables. When you open the application and run a form or report, the system automatically asks for the login/password. Many of the application users don't have access to the particular server which means someone needs to be there at 3:00 am to do nothing but login and run a report.
Is there a way to use vba to enter the login and password? Basically, we can password the vba code from being read by users so I am hoping it is possible.
:dunno
Here is the problem. I have several Access applications that use many of the tables. When you open the application and run a form or report, the system automatically asks for the login/password. Many of the application users don't have access to the particular server which means someone needs to be there at 3:00 am to do nothing but login and run a report.
Is there a way to use vba to enter the login and password? Basically, we can password the vba code from being read by users so I am hoping it is possible.
:dunno