By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Problem with exporting text files to system folder in Access 2010

AR Ratheesh
P: 25
Hi,

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
Share this Question
Share on Google+
3 Replies


100+
P: 759
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

P: 16
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

NeoPa
Expert Mod 15k+
P: 31,494
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.