how to change user

  • Thread starter Thread starter James
  • Start date Start date
J

James

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!
 
James said:
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"...
Click to expand...

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!
Click to expand...

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.
 
James said:
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!
Click to expand...

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
 
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.
 
James said:
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.
Click to expand...

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
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.
Click to expand...

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
 
Back
Top