Sessions

[Ryan]

I have created my own security in access. Does access have session state?
What I would like to do is have a text value (which is my users login and
password) saved in a session so that I dont have to keep a form open for all
my other forms to grab the login and password. Right now I have a form
called User that stays open and all my quries and forms are filterd with the
username of the User. This works great, but some people have started closing
the form (by right clicking it on the task bar) which is causing some serious
problems. Thanks for the help in advance.

 

[Chris O'C via AccessMonster.com]

Why aren't you using Access's built in security? It's probably a lot less
work than creating your own, and probably more reliable.

Access has a session state. Each user has his own session when he opens the
db. If you're thinking a web app session state with session variables, it
doesn't work that way with databases. With a split db, your app can save
data separately in a table in the front end because no one else is sharing it.


Don't store user logins and passwords in Access tables unless you want to get
fired for security breaches.

Chris
Microsoft MVP