[AccessD] No Permission?

Tue Sep 28 06:05:00 CDT 2004

I log in as having administrative rights but not as The Administrator.  I don't like the XP set up, so I created a new folder on the C drive called My Documents and I ignore the XP My Documents which is buried somewhere.

Thanks for the suggestions, I shall look into those issues.

Gary J. Giever, M.A.
Applications Developer
ACCMHS
3285 122nd Avenue
PO Drawer 130
Allegan, MI  49010

 --- On Mon 09/27, MartyConnelly < martyconnelly at shaw.ca > wrote:
From: MartyConnelly [mailto: martyconnelly at shaw.ca]
To: accessd at databaseadvisors.com
Date: Mon, 27 Sep 2004 14:57:07 -0700
Subject: Re: [AccessD] No Permission?

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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com