Re: Back-End Security question

Dear Rick -

Thanks for your comments. I did split the database prior to running
through the security wizard. After splitting, I applied security to
both sides using the same security file settings - this is how the
shortcuts were automatically added to the desktop.

There is only a problem when I try to open the back-end through Windows
Explorer. If I use the shortcut the Wizard provided, I am required to
enter a username and password. But, if a user navigates to the back-end
location through Windows Explorer, the file opens without prompting for
a username and password.

I will give it another try - not sure where I can be missing a step,
but I must be missing it somewhere.

Thank you again!

Tammy


Rick Brandt wrote:
Tammy wrote:
I have a secured front-end and back-end database. (I did use the
security wizard for this.) By using the shortcuts provided, both files
require a password to get in.

Here is the problem: if I try to access the front-end through Windows
Explorer, I do get the prompt stating it cannot be opened. However, I
am able to open the back-end without a prompt.

That is not normal nor correct. Your back end is not secured properly if
you can do that.

If you used the database splitter wizard to split the database after
applying security then that is the problem. The splitter wizard creates a
back end that is not secured.

Create a new blank file while logged in as an administrator in your secure
workgroup and then import all of your back end tables into it. This will be
your new secured back end. Apply permissions as appropriate afterwards.
You should find that the new file will be like your front end in that it can
only be opened when using the appropriate workgroup and after logging in.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

.

Relevant Pages

  • Re: How to remove password dialog?
    ... around with Access security anymore. ... Don't run the wizard. ... >wizard to secure your ... >> database. ...
    (microsoft.public.access.security)
  • Re: Used security wizard but no logon prompt?
    ... Don't use the Security Wizard in Access 2K. ... You are still joined to the default workgroup, not your secure workgroup. ... only when opening the secured database. ...
    (microsoft.public.access.security)
  • Re: Password Problems
    ... > I used the User Level Security Wizard. ... How did you open the database? ... Did you use the desktop shortcut the wizard ... you should not have set a password for Admin (the ...
    (microsoft.public.access.security)
  • Re: Error - "Not valid account name or password"
    ... > I am pretty new to Access Security, but have successfully run the security ... > wizard for one set of users on a simple two-table mufti-user database. ... > letter in the path of the secured .mdb icon. ...
    (microsoft.public.access.security)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
Loading