Re: More security questions

Joan,
I mis-stated one thing below. My MDB is BladeRunner.MDB which is in a
directory under MyDocuments\BladeRunner. The security file is Security.mdw
and there is a Security.ldb all in the same directory. I created a shortcut
but when I launch, I get the same permission message.

I am by default using the secured mdw:

? dbEngine.SystemDb
C:\Documents and Settings\Joe\My Documents\BladeRunner\Security.mdw

I am still not prompted for a password, but appear to be logged on as Admin.
I cannot change the admin password, and it tells me that the old password is
incorrect. I see the users that I created, but cannot change those passwords
or get prompted to log in.

I am sure confused and getting nervous about this...I have invested a large
chunk of time in this development effort, and sure hope you can help me
understand what I've done here. Thanks again for your help.

Joe





"Joan Wild" wrote:

"Joe G" wrote:

Hello Joan !

I have an MDB file that I secured a few weeks back which was working fine.
I did something yesterday when I unzipped a backup copy of the database
(although I unzipped it to a different directory) that has caused me problems.

I have an MDW file of the same name as the MDB, residing in the same
directory.

That's not a good idea. Both the mdb and the mdw need to create an
associated ldb file. They can't if they have the same name. Rename the mdw
file (and then modify any shortcuts as necessary).

I join the workgroup for the MDB - which has the two users that I created
when I secured the database, but when I try to open the database, I get the
message about not having the necessary permission and to contact the system
admin.

Are you certain you have joined the correct mdw file?

I am thinking that I am logged in as the universal admin (since I am not
prompted for a password) and am wondering how I go about trying to log in as
the user I had created when I secured the database who has amin permissions.
I am not being prompted to log in as I used to be.

When you open Access, go to Workgroup Administrator and verify the mdw you
are using by default. It should be the standard system.mdw that ships with
Access. Use a desktop shortcut to launch your secure mdb.
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

When you launch via the shortcut, you should get a login prompt. If you
don't then perhaps you've somehow cleared the password for the 'Admin' user
or your shortcut has a problem, in which case it will use system.mdw. In
either case hit Ctrl-G and type DbEngine.SystemDB which will tell you the mdw
it is *using*.

If it is your secure mdw then go to Tools, security, accounts, password tab
- it will show you that you are logged in as Admin - set a password for this
user.

If it is the system.mdw then your shortcut has an error in it.

--
Joan Wild
Microsoft Access MVP

.

Relevant Pages

  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • Re: Security not clicking
    ... split the database when it is secure or when it is not secure? ... mdb, with the same name, but it'll have a bak extension. ... You can use Start, Search, Files and Folders, and locate all mdw ... unsecured database to continue enhancing security. ...
    (microsoft.public.access.security)
  • Re: Workgroup file security failure?
    ... >> secured in a single mdw file, ... you can secure many mdb files with a single mdw. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I am going to make an .mde out of this database. ... Did you set an Admin Password in your new mdw? ... When you launch the shortcut does it ask you to authenticate with your ... use it for that mdb. ...
    (microsoft.public.access.security)
Loading