Logging On

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

Is there a way to change user's without completely
closing access?
I have a database used by several users. All of the
entries are user specific (user id's are stamped on any
records they enter). It would be nice if there was a
button one could click that would display the database
log on prompt. As it is now, when one user is finished
he/she has to exit out of the database. Then the next
user must re click on the desktop short cut to bring up
the log on prompt.
TIA
 
Is this located on one machine that different users go to, or is it
located on a LAN and the different users access it via the LAN?
 
Antonio said:
Is there a way to change user's without completely
closing access?
I have a database used by several users. All of the
entries are user specific (user id's are stamped on any
records they enter). It would be nice if there was a
button one could click that would display the database
log on prompt. As it is now, when one user is finished
he/she has to exit out of the database. Then the next
user must re click on the desktop short cut to bring up
the log on prompt.
Click to expand...

If you are using user-level security, you must restart the application and
Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
My guess is you will be able to do what you want, only if you use user
level security and break the database into a back end (on the server
containing the actual data) and a front end (on each machine containing all
the forms most if not all queries reports etc.
 
Back
Top