Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Logon screen though not secured (A2K)

    Hello,
    On one computer in my office, I had recently copied one of my databases, renamed it, and secured it for distribution to a read-only user. I deleted the copy, and the secured file, etc...however when I open the original copy, I still get the secured Logon form on startup? How can I stop this from showing up?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    Hi,

    Did you try Tools...Startup, and removing it from the startup options, (Display/Forms drop down)?
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Logon screen though not secured (A2K)

    If by "Logon form" you mean a form in your database, Nannette probably pointed you in the right direction.
    Otherwise, as long as you are member of a .mdw file with a password on the default Admin user, you'll be prompted for a username/password. You can create (and become member of) a new .mdw file.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    Hans,

    Your solution was more along the lines I was looking for, is there a way to delete the .mdw file? I dont know where it resides....and I get the Logon even if I try to open a blank database...

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Nannette - thanks for your advice <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Logon screen though not secured (A2K)

    You have to run the Workgroup Administrator program. The default location for the US version of Access 2000 is

    C:Program FilesMicrosoft OfficeOffice1033WRKGADM.EXE

    You can use this program to
    - See which .mdw file you're currently a member of.
    - Switch to another existing .mdw.
    - Create a new .mdw, which will be unsecured by default.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    Always Jeremy...
    Didn't think you would bypass that easier solution in your troubleshooting, and know your database is very complex...just took a chance...as sometimes its the easiest things we trip on.
    [img]/forums/images/smilies/smile.gif[/img]
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  7. #7
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    Hans,
    That worked great, but leads me to another question (just for info)...what is the significance of the 1033 folder? There are folders named 1033 in nearly ever folder under Microsoft Office....

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Nannette - that happens all too often to me...shhhh <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Logon screen though not secured (A2K)

    1033 is the code for US English. Microsoft has a multilingual version of Office (only available to large corporate accounts, not to individual customers) that enable you to switch the language of the Office interface (menus, dialog boxes, help files, ...). If you have that, you'll see such folders for each installed language, for example UK English = 2057, Dutch = 1043 etc.

  9. #9
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    So you're brain isn't really a brain is it....just a series of hard drives hard-wired to a backpack you carry everywhere. Wow, thanks for the info! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logon screen though not secured (A2K)

    I was reading on that...and there is a blog on just that subject....

    http://blogs.msdn.com/oldnewthing/archive/.../09/151689.aspx

    I never thought about it until you asked....learned something new today...<img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  11. #11
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Logon screen though not secured (A2K)

    Sounds like you were Jeremy's teacher once with that advice <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •