Login to Access

[Guest]

We recently upgraded from Office 2000 to 2007, when opening a database when
we had 2000 you had to login with a user id and password, this told the
software who was entering data, since the upgrade the login no longer appears
and everyone is shown as an Admin. All the users are not missing, I've tried
adding new users but the login window still does not appear when opening a
database, how do I get it back?

 

[Joan Wild]

The fact that you don't get a login screen, suggests that it never was secured properly (even in 2000).

I assume this is a mdb, and not a accdb. If you converted to the accdb, then security is gone; it's not supported in 2007. If you kept the mdb format and are just using 2007, then you can create a desktop shortcut to specify the secure mdw to use.
The target would have the following in it:
"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

However, you'll still have the problem that it isn't secure.

 

[Guest]

Actually its a .mde file, I haven't converted the database, this seemed to be
a global setting, as whenever you open any access database file it required
you to login. I have seen the target path you gave in this forum and tried
it but just got an error message, I think I'm not understanding the part with
the \wrkgrp. should that be in ""? We had it setup that way so we would
know who added a record, international and FDA requirements.
Thanks for your help.

 

[Joan Wild]

It should be /wrkgrp not \wrkgrp. That tells access to use the mdw specified in the path that follows (rather than the mdw that is set as the default).

--
Joan Wild
Microsoft Access MVP

Actually its a .mde file, I haven't converted the database, this seemed to be
a global setting, as whenever you open any access database file it required
you to login. I have seen the target path you gave in this forum and tried
it but just got an error message, I think I'm not understanding the part with
the \wrkgrp. should that be in ""? We had it setup that way so we would
know who added a record, international and FDA requirements.
Thanks for your help.

 

[Rocky]

another thing you may try, since you don't need to assign actual user
rights, and only need the name, in the table, create the UserCreated field.
Then on the form you need to know who did something, set the default to
=Environ(USERNAME). Lock the field on the form, and they can't change this.
I don't know if this helps, I hope so.

 

[scotsman]

Oops, thanks, why did they decide not to support security in 2007, doesn't
amke sense considering all the hype about security right now.

 

[Joan Wild]

Oops, thanks, why did they decide not to support security in 2007, doesn't
amke sense considering all the hype about security right now.

That's probably why right there. Access 'security' isn't secure at all. I would have preferred they kept it, but called it something else, so that we still had an application guidance system. However they decided to drop it entirely.

It is still supported in 2007, but only for the mdb format, not accdb.