469,086 Members | 1,235 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,086 developers. It's quick & easy.

Problem with exporting text files to system folder in Access 2010

AR Ratheesh

I have Access 2010 and When i'm trying to Export Text files to System folder ("C:\Windows\abc.asc"), in Windows 7 ultimate, couldn't export.

But Previously i successfully exported to "C:\windows" in windows xp.But Windows 7 blocks the exporting. Export to other folders is easy and working fine.

My Export specification name is wintrl and table is AccountTrl.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acExportDelim, "wintrl", "AccountTrl", "C:\windows\abc.asc", False    'This code makes permission error message
  2. DoCmd.TransferText acExportDelim, "wintrl", "AccountTrl", "C:\Users\Alon Rajan Ratheesh\Desktop\abc.asc", False  ' but here all working fine
How to Export to "c:\windows\" without permission problem?

Any suggestions are highly appreciated.

AR Ratheesh
Sep 17 '11 #1
3 2676
759 512MB
I don't know Windows 7 but I think that is a Windows configuration that allow you (or not) to write in the system folder.
Right click the system folder and see the Properties. Maybe you find an answer.

Good luck !
Sep 18 '11 #2
Welcome to Windows 7. You'll need to be signed on to an Admin user windows account to write to the Windows system folder. I'd advise against it. Instead, write to a folder that you're allowed access to. Create a "well behaved" application, and write to "%programdata%/MyCompanyName/MyApplicationName" or "%appdata%/MyCompanyName/MyApplicationName".
Sep 18 '11 #3
32,159 Expert Mod 16PB
I'm definitely with pdebaets on this one. Very good advice.
Sep 26 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Debbie CD UK | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.