Re: locked out

Access 2000 doesn't have Tools, security, workgroup administrator, so are
you sure you are using 2000 (or maybe the mdb is just in 2000 format). Go
to Help, About - that'll confirm the version.

If it shows system.mdw as the default, and you are not using a desktop
shortcut to start the database, then you have modified the standard
workgroup that ships with Access.

Check in the folder where the mdb is located. There may be a file with the
same name, but a bak extension. If you see this, then you can delete the
mdb, and rename the bak to have a mdb extension - this will be a backup of
the mdb that the wizard created before it secured your database.

Do a search (Start, search) on your computer for *.mdw. Rename each of
these (stick a number on the end of the name). Open Access - it should
create a new pristine system.mdw for you. Now see if you can open the
renamed mdb.

If you want to implement security, I suggest you read up on it first, and
practice on a copy of your database. If you really are using 2000, you
should know that the wizard is flawed; you'd need to secure it manually.
Some resources:Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm


--
Joan Wild
Microsoft Access MVP

Doreen wrote:
I am using Access 2000 and I have tried using a blank password but it
is still invalid. I want to delete this new database and start all
over but Access will not even give me that opportunity because it
needs a password. I have opened access, Tools, Security, Workgroup
Administrator shows that I am currently joined in the ( C:\Documents
and Settings\...\Access\System.mdw. Is there something I am missing
here?

"Joan Wild" wrote:

Doreen wrote:
Hi

I have created a database from an old secured databse by importing
tables, forms, queries, etc and that I managed with no problem.

If you managed that while joined to the standard system.mdw, then
the old database wasn't secured properly.

The
problem arose when I tried to secure this database. I used the
security wizard to create a new user. Now I cannot use the username
and password I created to open this database and I cannot even open
a blank database because I get a login window, the password and user
name I have is said to be invalid! Surprising I can open my old
database from the shortcut on my desktop but if I go into the folder
I cannot open it.

What version of Access? You might be confusing the PID with a
password. Try logging in with a blank password.

You get a login window, because you are joined by default to your
secure mdw - it will use this default until you change it (or use a
desktop shortcut that overrides it).

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: Office 12 Access Database Engine conflicts with DAO 3.6 librar
    ... the mdb I used to convert, this was already running in office 2007 and still ... I can see advantages to moving to accb secure encryption. ... Shame to lose workgroup security but like everybody else I just move ... succession planning and would rather work with SQL themselves because they ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to remove password dialog?
    ... I'd like to have no security setting at ... Backup your secure database ... >then open that bak file you renamed. ...
    (microsoft.public.access.security)
  • Re: Prevent copying to local HD
    ... probably confused issues by stating a database example. ... > security breach. ... We do have Citrix Metaframe. ... Even the passwords are not entirely secure ...
    (microsoft.public.windows.server.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: Securing data
    ... Access provides User Level Security, which is the most secure method ... Why would each staff member have their own database? ...
    (microsoft.public.access.security)
Loading