Z
ZRexRider
Hi,
I have an MS-Access 2002 ADP application that gets deployed to a large
group of people. Most of these users are able to use a "trusted
connection" but there are a dozen or so that are situated on a
domain/setup that will not allow "trusted".
Anyway, I have VBA setting the connection string based on the domain
used to connect. I deploy the application set up for trusted
connection. I have no issues with the trusted connection - works just
great.
However, using userid/password I have two issues:
1. I would rather the ADP file wouldn't try to connect to the database
at all on its own (during startup). I'd rather it let my VBA code do
that. As it stands today, since it's deployed as trusted it has a
delayed startup on first use since ADP trys to connect using trusted,
fails (quietly) and then my VBA builds the "real" connection and lets
the user in. I've been googling and it sounds like there is no way to
disable the ADP built in connection attempt. If someone knows
otherwise...
2. Since one of the objectives is to not prompt the user for "yet
another password" they asked me to use the same password for each user
for non-trusted members. So my code grabs their Userid from
Environ("Username"), pair it up with this common password and log them
in. However, the next time they open the application ADP prompts them
for the userid and password before it runs my VBA code. Is there a way
to save this info in the ADP so it stops pestering the user? There is
an option on the Data Link Properties panel (off the File|Connection
menu but I plan to never expose the user to that menu.
Thanks
so it doesn't prompt the user on start up. When the user runs it for
the first time the built in
I have an MS-Access 2002 ADP application that gets deployed to a large
group of people. Most of these users are able to use a "trusted
connection" but there are a dozen or so that are situated on a
domain/setup that will not allow "trusted".
Anyway, I have VBA setting the connection string based on the domain
used to connect. I deploy the application set up for trusted
connection. I have no issues with the trusted connection - works just
great.
However, using userid/password I have two issues:
1. I would rather the ADP file wouldn't try to connect to the database
at all on its own (during startup). I'd rather it let my VBA code do
that. As it stands today, since it's deployed as trusted it has a
delayed startup on first use since ADP trys to connect using trusted,
fails (quietly) and then my VBA builds the "real" connection and lets
the user in. I've been googling and it sounds like there is no way to
disable the ADP built in connection attempt. If someone knows
otherwise...
2. Since one of the objectives is to not prompt the user for "yet
another password" they asked me to use the same password for each user
for non-trusted members. So my code grabs their Userid from
Environ("Username"), pair it up with this common password and log them
in. However, the next time they open the application ADP prompts them
for the userid and password before it runs my VBA code. Is there a way
to save this info in the ADP so it stops pestering the user? There is
an option on the Data Link Properties panel (off the File|Connection
menu but I plan to never expose the user to that menu.
Thanks
so it doesn't prompt the user on start up. When the user runs it for
the first time the built in