Re: How to remove password dialog?

From: Kimmy (anonymous_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 10:34:16 -0700

Thanks again for your reply.
1) I have no more bakup file therefore, I cannot follow
your first method
2) I do not know how to "Go to Tools, security, WA and
ensure you are joined to system.mdw". Everytime, I go to
Wizard, I got message "... when you're both logon as Admin
User and db has been previously secured"
3) I go with the third solution which create new DB and
imports all objects to the new one. But all of my codes
(VB) were not imported !!! Do I have to copy and paste the
codes for each event of my forms?

The funny is when I copy my db and secured.mdw to
different machines, some of them I have to access thru a
shortcut, some of them I can access directly by double
click. It's driving me nuts.

Thank you for your time. It just because I am new with
Access. Kimmy.

>-----Original Message-----
>Kimmy wrote:
>> Thanks for your response
>> how can I get to the original state in which no pw
prompt,
>> no secured.mdw, I'd like to have no security setting at
>> all, just like when I created a new Access db.
>> Thanks again for your help.
>> Kimmy
>
>As I recall, you used the security wizard to secure your
database. If so,
>and providing you didn't decline, the wizard would have
kept an unsecured
>copy of your mdb. You'll find it in the same folder as
your mdb, but it
>will have a bak extension. Backup your secure database
first (in case this
>doesn't work), and then rename the bak file to have a mdb
extension. Open
>Access and ensure you are joined to the standard
system.mdw that ships with
>Access (it's in the windows system folder). You can use
Tools, Security,
>Workgroup Administrator to check/join this workgroup.
Close Access, and
>then open that bak file you renamed. If you are back to
normal, then you
>can delete the 'secured' database, and the secured mdw.
>
>If you don't find the bak file, then you can unsecure
your database by
>logging in (using the secured mdw file) as a user that's
a member of the
>Admins group. Assign full permissions to every object to
the Users group.
>Go to Tools, security, WA and ensure you are joined to
system.mdw. Then
>close Access. Re-open Access and create a new database
(you should get no
>login); import all objects from your database and
compact. This new
>database will be unsecured, and you are safe to delete
your old one and the
>secure mdw file.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>

Relevant Pages

  • 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: 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)
  • Re: locked out
    ... Access 2000 doesn't have Tools, security, workgroup administrator, so are ... Check in the folder where the mdb is located. ... the mdb that the wizard created before it secured your database. ... should know that the wizard is flawed; you'd need to secure it manually. ...
    (microsoft.public.access.security)
  • RE: Security of Password-Managers
    ... Another way that you could keep yourself secure is to group passwords into ... Personally, I don't like to keep everything in one database, it may seem ... 1024 should be hard to crack security. ... >By the way, your English is fine. ...
    (Security-Basics)
  • Re: How to remove password dialog?
    ... you used the security wizard to secure your database. ... and then rename the bak file to have a mdb extension. ... and the secured mdw. ...
    (microsoft.public.access.security)