Problem with exporting text files to system folder in Access 2010

[AR Ratheesh]

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.

DoCmd.TransferText acExportDelim, "wintrl", "AccountTrl", "C:\windows\abc.asc", False    'This code makes permission error message
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

[Mihail]

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 !

[pdebaets]

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".

[NeoPa]

I'm definitely with pdebaets on this one. Very good advice.