Re: Lost logon

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 17:42:08 -0500

I'm confused. What does this have to do with your original question?

The only way that the Admin password was changed to blank, was that someone
(a member of the Admins group in the Access mdw file) went to Tools,
security, Accounts, and clicked on Clear Password - perhaps by accident. In
other words, Admin is the first user in the list. They may have forgotten
to select the correct username, before hitting Clear Password, and as such
cleared the password for Admin.

As far as concerns about giving users full permissions to the folder. Yes
that is required. You can hide the folder so it isn't so easy for them to
get to and delete files (use \\server\share$ rather than \\server\share).
You can also deny delete permission on the mdb file, however when you
compact you have to remember to reset the deny permission. Of course,
you'll have backups should someone delete it.

Also for multiple users, you should split the mdb and put just the backend
on the server. Give each user a copy of the frontend on their local
machine. 

-- 
Joan Wild
Microsoft Access MVP
"mikew" <anonymous@discussions.microsoft.com> wrote in message
news:7F610D7E-B34C-4C5A-BA14-211393A89923@microsoft.com...
> That did the trick.  Many thanks.  Now back to the first problem of
multiple simultaneous access to the db. Can you comment on this statement
from another thread:
>
> "The problem is that you apparently have to give full read-write WINDOWS
> permissions to the folder where the database is located for a user to even
> open it, else you get an "already in use" error. Problem is, in doing
this,
> you leave open the risk that someone could outright delete the files."
>
> Since all was working fine until a certain point at which, I surmise, a
change to the network took place, do you give any weight to the statement as
being contributory to my problem?  IT has denied any change took place - but
I see Novell Network on my computer when I didn't see it before.

Relevant Pages

  • Re: NTFS - Restrict file deletion
    ... NTFS permissions are XP standard. ... File is in folder. ... the Admin from deleting a file or folder. ... check on "Inherit from Parent...", click Apply, click ...
    (microsoft.public.windowsxp.general)
  • Re: Word mail merge data source
    ... we still did not get it working using UNC. ... Word on it) then there may be a problem if the folder containing the data ... but just because a user has full admin rights does not necessarily ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • Re: Word mail merge data source
    ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... but just because a user has full admin rights does not necessarily ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • RE: Share permissions question
    ... Thanks for your prompt reply and valuable info David. ... Ex boyfriend b/c he set up computer obv knows my admin rights number. ... there are application folders that require special permissions such as ... With the Advanced Security Settings Permissions (Traverse folder, ...
    (microsoft.public.windows.server.general)
  • RE: Share permissions question
    ... David Davis ... Ex boyfriend b/c he set up computer obv knows my admin rights number. ... there are application folders that require special permissions such as ... With the Advanced Security Settings Permissions (Traverse folder, ...
    (microsoft.public.windows.server.general)