I can secure my database through a workgroup
Now i dont want a read only user having to log on with a password, i
want it secure from backend intrusion but no pasword
Microsoft says you can do this.
I just dont seam to get it.
It says remove the Remove the Admin user from the Admins group, an
error says no.
Any help please
here it is
Securing Your Database Without Forcing Users To Log On
If you want to secure some objects in a database (such as your
modules), but you don't care about granting different permissions to
different classes of users, you might want to consider securing your
application without making your users log on.
1. Follow the steps to secure a database using the Security Wizard.
2. While logged on as a member of the Admins group (in this case,
Joe), assign permissions that you want to be generally available to
the Admin user.
3. Remove the Admin user from the Admins group. This prevents users
who are logged on as Admin from granting themselves further
permissions.
4. Clear the password from the Admin user. Users will be able to open
your database without logging on and will be able to perform all
actions to which you give the Admin user permissions.
Now you need a way to perform administrative duties such as setting
permissions and assigning users to groups. Because you have removed
the Admin user from the Admins group, you won't be able to perform
these actions when logged on as Admin. And because the Admin user has
no password, the Log on dialog box won't appear. You'll need to log on
as Joe (or another member of the Admins group) to perform these
duties. You can do this by editing the command-line argument of the
Microsoft Access Program Manager icon to include Joe's name and
password using the /User and /Pwd command-line options. When you start
Microsoft Access using this icon, even though you don't encounter the
Log on dialog box, you will be logged on as Joe and will be able to
perform administrative duties.
Of course, if you chose to keep this icon on your computer, rather
than deleting and re-creating the command line each time, you'll have
to make sure your computer is physically secure, because someone could
copy the user name and password strings arguments from the command
line and gain access to your system.
