[AccessD] No Permission?

MartyConnelly martyconnelly at shaw.ca
Mon Sep 27 16:57:07 CDT 2004


Are you sure you are logging on as administrator and not another user name?

Try this code to indicate your user name at logon
http://www.mvps.org/access/api/api0008.htm

Generally with a named user login "my documents" folder for user "marty" 
would look like
C:\Documents and Settings\marty\My Documents\Access\
or
C:\Documents and Settings\All Users

rather than

C:\My Documents\Access\



unless you have moved it, somehow

You could have a clobbered user profile which I  am not sure how to correct.

Try this code to see what is happening
Sub mydocfolder()
Dim MyAppPath As String
Dim wshShell As Object
Set wshShell = CreateObject("wscript.shell")
MyAppPath = wshShell.SpecialFolders("MyDocuments")
Set wshShell = Nothing

Debug.Print MyAppPath
Debug.Print fOSUserName
End Sub

See this article (it takes a second or two for the right frame to load)
http://securityadmin.info/faq.asp#ownership


 If this is Pro, you need to disable simple file sharing using
the Folder Options control panel, and then if you are using an admin
account, you can see the security tab.

Open Windows Explorer and right-click your "My Documents" folder. Then
select the Sharing and Security option and click the security tab. You
should see Administrators group, SYSTEM, and owner listed with full
control, but likely you won't see owner listed and if owner is not part
of the Administrators group, then that explains why you can't access the
folder.

Click the advanced button and click the owner tab. If the owner is
Administrators, then leave it alone, but if the owner is some long
string of numbers, you need to click Administrators and the checkbox
that says to apply this to all subfolders. Then click OK. Now the folder
belongs to a real account (and if you reinstall again, it won't be an
unknown account, it will continue to be Administrators group).

If owner does not appear in the list of accounts, then add owner and
give owner "full control". Make sure that this is applied to all
subfolders and files.

Reboot to normal mode, logon as owner and try to access the folder
again.


Gary J. Giever wrote:

>I have an annoying problem with Access 97 that began when I switched from Windows 98SE to Windows XP Pro.  Now when I try to re-link tables, I get this message from the Linked Table Manager:  "You do not have access to the folder 'C:\My Documents\Access\In Progress\*.mdb'.  See your administrator for access to this folder."  Most of the time it lets me re-link the tables anyway, but sometimes it will not.
>
>This is confusing since I am the administrator and only user of this computer.  I have checked the Security settings under properties for the files and I seem to have permission.  Any ideas?
>
>
>Gary J. Giever, M.A.
>Applications Developer
>ACCMHS
>3285 122nd Avenue
>PO Drawer 130
>Allegan, MI  49010
>
>
>
>Gary J. Giever, M.A.
>Applications Developer
>ACCMHS
>3285 122nd Avenue
>PO Drawer 130
>Allegan, MI  49010
>
>
>_______________________________________________
>No banners. No pop-ups. No kidding.
>Make My Way your home on the Web - http://www.myway.com
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list