I recently adjusted certain security settings using the User Security Wizard,
and I need to change the settings, but now it won't let me, since I was the
user who changed them previously. also, the "user" the program is referring
to is the default Admin user in the Admins group. ...

is there a way to have some users gain access to some fields on a form and
prevent other users access to those fields from the same form based on their
log-in ids?

This is probably pretty simple, but I've spent too much time trying to figure
it out on my own.
I'm using Access 2007, SQL Server 2005 (Windows Authent), Windows Server 2003.
Multiple users share computers, so I need to create a login feature in

I have created a database and now need to secure and distribute to 12 users.
I have split the db and have two versions of the FE.  I do not how the best
way to secure and distribute.
Please help!!

I am trying to figure out if there is a way to keep records in alphabetical
order during record entry in a database form?  If a person adds a new record
or several new records, I would like those records to be saved in
alphabetical order.  Is that possible?

I have a few questions, but a little background first.  I have created a
database for 13 users.  Each user has a login and a password, and that is
working fine.  The database opens to a form that the user has to fill out.  
It has 5 tabs on the form to fill out.  The only other ...

I have tried for two weeks now to get the secyrity user to work. My problem
is I can get it to only work on my computer. I want ot set up users and have
everyone in the office enter a password to get into the database. Can some
one please help?

Would inserting extended characters into login passwords make my accounts
more secure ?
By extended characters, I mean those in the "Windows: Western" or "Unicode"
character set that you type by pressing ALT+number.  For example:  § ‡ è

From SQL Server 2000 I have to link to an MS Access file that has a database
password but no user-level security (as far as I'm aware).  I could not get
the OLE DB provider for Jet to authenticate and instead had to create an ODBC
System DSN

Last summer, Joan Wild helped me tremendously, when I locked myself out of my
database...Well, I have done it again !
This client was quiet all winter, but his business being seasonal, he's now
asked me to resurect the project. Only problem is, I can't get into the

I recently created an Access database and used the One-Step Security Wizard
to set parameters for users of the database.  I printed out the report that
has the user names, personal ID's, and passwords.  However, the passwords are
not working.  I backed up the database on a CD.  ...

I don't know whether I'm the right forum or not.  I'm facing a problem at
work - there's a database I need to access to make revisions to the data as
well as adding data.  The person who created this database has left the
company and will not divulge any information pertaining to ...

Is there any way at all to set the security level to Low on the Security
Level in the Runtime version of 2003?
I have a database with a macro that I want to schedule to automatically run
at night but it sticks waiting for you to click Open.

I have split my db into BE/FE.  There are no permissions assigned on tables
on BE to group AppUsers.  This group has full permissions on FE to tables,
forms, queries.  I have converted all my tables to rwop queries and use them
in all my forms.  It has been successful except for ...

Even if you secure your MS Access database using proper procedure, a
user can create a new access database and use his password to link to
the backend data.  This will allow him to bypass any restrictions to
the data that your client might have.  I've looked through years of