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