No security asks for password

  • Thread starter Thread starter Luke Bellamy
  • Start date Start date
L

Luke Bellamy

Hi - I have an Access 2002 runtime mde. When a particular user opens it on
their computer
they say it prompts them for a login. I have no system.mdw file associated
with my app.
I have no logins associated with my mde app at all.

I don't know much about security but I'm guessing this user has a "global"
system.mdw
file that is being referenced on their computer when any Access database is
opened.

Is there a simple way to remove this?
Can anyone explain a little but more on why this happens?

My app was distributed using Access 2002 runtime and I have a single mde
file that is
included in the shortcut I provide.

Thankyou
 
Hi, Luke.
I'm guessing this user has a "global"
system.mdw
file that is being referenced on their computer when any Access database is
opened.
Click to expand...

The user is joined to a workgroup that has a password set for the Admin
user. Since your database application does not have any user-level security
applied, this user is obviously joined to the wrong workgroup.
Is there a simple way to remove this?
Click to expand...

Yes. For more instructions on the steps necessary, please see the "How to
open databases and only be prompted for User ID and password for the secure
databases" tip on this Web page:

http://www.access.qbuilt.com/html/security.html
Can anyone explain a little but more on why this happens?
Click to expand...

It's like Newton's law: a body at rest tends to stay at rest. Once the
user joins a workgroup, the user _stays_ with that workgroup -- until the
user joins another workgroup. Your user has joined a secure workgroup, and
so must authenticate every time Access opens or creates a database.

To make life simpler, most people stay joined to the default workgroup
(System.MDW) and just use a shortcut that has the command-line switch that
identifies the secure workgroup file to join whenever the secure database
needs to be opened. The user will only be joined to this secure workgroup
for the duration of the session. Once the user quits the secure session,
the next time a database is opened by the user, the user will be joined to
the default workgroup, unless that "secure" shortcut is used again, at which
time the user will be prompted for User ID and password.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top