how to connect as a different user at runtime (in code)

J

Jay

Is there a way to startup an Access 2002 app with the default admin user,
then have code which when executed will connect to a different user?
This app starts without any login prompt which I understand means it is
using the default admin user.
My purpose for this is to provide additional privilages for a function at
runtime that does object deletes (docmd.deleteObject). I have taken away
this privilage from the default admin to secure the app from my users.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I switch the current user from the default (Admin)? 1
Running ms access modules as admin but logged into access as a regular user.. 2
how to disable login for Access 2002 mdb file 5
Open a Database by VB Code to join a different workgroup 2
Securing DB on a network drive 3
Cross Post 'Security - DAOVBA': Updatiung Secured Back-end in code from Front-end in Runtime environ 0
How to Add a Right Click Menu to A Form in Access 2007 in the RunTime Environmane 6
Loading Workgroup Admin in runtime & a Digital Certificate Question 6

Top