By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Set User in AutoExec or VBA, like Command /user???

P: n/a
With the command '/user username' I can connect to the access-db as
the specified user. How can I set the user with an the AutoExec makro
or in the VBA-Code?

Thanks a lot
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Gabriel K." <kp******@web.de> wrote in message
news:c3**************************@posting.google.c om...
With the command '/user username' I can connect to the access-db as
the specified user. How can I set the user with an the AutoExec makro
or in the VBA-Code?


You can't. The username is established when Access is launched before your
mdb file is even loaded so there is no way for any of your code or macros
to influence it. You could first launch a dummy app whose only purpose is
to launch the real app with a username specified.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.