Discussion:
Unable To Create Text File in C:\ Drive Due To Security ???
(too old to reply)
Gary
2010-01-27 00:28:01 UTC
Permalink
I am using Win 7 Pro (64-bits) with Access 2007. I am using VBA code that
should create a text file at "C:\" and I am getting an error. I think the
error is due to permission. It works if I change the location to a folder
like "C:\OTA\".

I have tried making myself part of the Admin group, and this still didn't
help.

Can someone please tell me what I need to set to allow myself to be able to
create a text file on the c:\ drive ???


Thank You,

Gary
Pegasus [MVP]
2010-01-27 07:09:13 UTC
Permalink
Post by Gary
I am using Win 7 Pro (64-bits) with Access 2007. I am using VBA code that
should create a text file at "C:\" and I am getting an error. I think the
error is due to permission. It works if I change the location to a folder
like "C:\OTA\".
I have tried making myself part of the Admin group, and this still didn't
help.
Can someone please tell me what I need to set to allow myself to be able to
create a text file on the c:\ drive ???
Thank You,
Gary
Use the method you discovered yourself: Create a folder such as C:\OTA, then
create the file in this folder. Alternatively, use the %temp% folder to
create your file.

Loading...