how to change user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 15 Jun 2006 14:50 GMT

Ok... I'm following the SECFAQ.doc trying to secure one database while
still allowing access to it in another database. On step 5 it says to
"quit microsoft access and log back on as the new user"... well I can't
figure out how to get out of the default user "Admin". I've already
created a new user along with following steps 1-4. Let me know if you
have any ideas, thanks!

Reply to this Message

Joan Wild - 15 Jun 2006 15:24 GMT

In my copy of the FAQ that is step 6, so perhaps you've missed a step?

> well I
> can't figure out how to get out of the default user "Admin". I've
> already created a new user along with following steps 1-4. Let me
> know if you have any ideas, thanks!

Step 3 you set a password for the Admin user. It's this that causes the
login dialog to show up.

In order to secure your database correctly, it is critical that you follow
each step (every phrase), in order.

Missing just one thing could result in an unsecure mdb.

You also should tell us what version you are using. In recent versions, the
login won't show up until you actually open a mdb file.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

James - 15 Jun 2006 15:51 GMT

Well I'm using Access 2003, but its creating a Access 2000 file... but
I think i figured that part out that I was having problems with.... but
I don't think this is giong to do what I want it to. It seems that I
have set permissions for every database on my computer, I wanted those
logins to be specific for one mdb. Does that make since? Like when i go
to log onto a completely unrealated db I have to enter the login and
pw...doesn't make since to me.

So here's my scenario.. tell me if it's even possible... I've got two
mdbs... mdb 1:forms/code for users/admin . It also has some password
restricted areas (logins and pws are stored in mdb 2). mdb 2 contains
all the data. It also contains some admin forms for adding users and
passwords and deleting users and passwords. I want users to have access
to mdb 1 and from there be able to read/write data from mdb 2. But, I
want to restrict mdb 2 to admin ... I don't want users to be able to
log in directly. Can I specify by table which ones are accessable by
users vs admin... It sounds really complicated for my minimal access
skills... let me know if you think its possible.

> > Ok... I'm following the SECFAQ.doc trying to secure one database while
> > still allowing access to it in another database. On step 5 it says to
[quoted text clipped - 17 lines]
> You also should tell us what version you are using. In recent versions, the
> login won't show up until you actually open a mdb file.

Reply to this Message

Joan Wild - 15 Jun 2006 16:14 GMT

> Well I'm using Access 2003, but its creating a Access 2000 file... but
> I think i figured that part out that I was having problems with....
[quoted text clipped - 3 lines]
> Like when i go to log onto a completely unrealated db I have to enter
> the login and pw...doesn't make since to me.

When you created the secure mdw, Access made it the default one to use for
every session. Access always uses a mdw file (even for unsecured
databases). It ships with system.mdw and uses that as the default, silently
logging you in as 'Admin' user.

So all you need to do, is re-run the Workgroup administrator and join
system.mdw to make it the default. For your secure mdb, create a desktop
shortcut that specifies a different mdw to use for just that session. The
target would look like
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

All other sessions of Access will use system.mdw with no login.

> So here's my scenario.. tell me if it's even possible... I've got two
> mdbs... mdb 1:forms/code for users/admin . It also has some password
[quoted text clipped - 6 lines]
> accessable by users vs admin... It sounds really complicated for my
> minimal access skills... let me know if you think its possible.

What you describe is quite typical, I'd say. You can remove all permissions
on the tables, and use RWOP (run with owner permission) queries in the
frontend for all data interaction. Read more about RWOP at
http://www.jmwild.com/RWOP.htm

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Keith Wilby - 15 Jun 2006 15:25 GMT

> Ok... I'm following the SECFAQ.doc trying to secure one database while
> still allowing access to it in another database. On step 5 it says to
> "quit microsoft access and log back on as the new user"... well I can't
> figure out how to get out of the default user "Admin". I've already
> created a new user along with following steps 1-4. Let me know if you
> have any ideas, thanks!

Access should be prompting you for a username and password, if it isn't then
you've missed something out. You need to give the admin account a password
to enable the prompt.

Regards,
Keith.
www.keithwilby.com

Reply to this Message