Question Access User Control Issues

[brharrii]

I'm using access 2010

I was playing on a test database with the "users and permissions" and setup a user account that I can't seem to get rid of. The user account is requiring a user name and password in order to get into the database. Because it was in a test database I thought I was going to be ok to play around as much as I wanted to without doing anything permanent, but somehow that user sign on is now required in every database on my computer. Not just the one I was playing with.

How can I delete the user account so that no sign on is required to enter the database.

As a side note, people accessing the same database from another comptuer don't need to enter a password to get in. It seems to be something local to my computer.

Additionally in my messing around I took away my administrator privliges under this account so I may be somewhat limited in what I can do.

:banghead:

 

[brharrii]

I should add that I have the user name and password and am able to access the database still, I just want it to stop asking me for it every time I go in.

 

[brharrii]

Thanks Pat,

I didn't realize that this was no longer a preferred function. I'm relatively new to access and still don't know all the way what I'm doing.

I've been trying to setup a system that will allow me to record any changes and who did them to a form in my database. I have the general Idea figured out, I'm just trying to figure out how to make people sign in when they open the database so that any changes the perform will record their name. I also need to restrict most functions from being used by a few users.

Anyways, that's my project today. If you know an easier way to do it, I'd appreciate any push in the right direction

Thanks!

 

[brharrii]

Thanks again Pat,

I've got a walk through for creating an audit log, This is what I'm using:

http://www.techrepublic.com/article/a-simple-solution-for-tracking-changes-to-access-data/6166807

The thing that isn't quite clicking for me is:

how does Access know the user's name? Does this need to be stored on a table somewhere? does it get it by knowing the computer name? etc

I built a form that asks for a user name and password which are matched to a table i created. I'm just not seeing how or if the code here ever links back to it.

 

[stergio33]

You can retain the user level security from access 2003, as long as you keep the file in mdb format (or mde). If you don't want access 2010 to keep asking you to login, login as administrator, then click 'file' then you see a tab that says: 'manage users & Permissions', click it and choose 'user and group accounts'. Then make sure that admin in in administrators group, reset it's password, and delete all other users. After restart of access, you will not be asked for a user name any more.
But, accde file format is much better. Read security of access 2010, is much safer than 2003. You must establish a safe point location.
To convert to accdb format, go to 'file' then to 'save & publish' then 'save as'.

 

[stergio33]

The man said that he wanted to retain the uls. That's is why I suggested the way to do it.
Have you ever jumped off a bridge? Is not a good idea at all!