[AccessD] Make Folder Problem

Does the user have Admin rights? 


Karen S. Long
Programmer Analyst
EG&G Technical Services, Inc.
Pittsburgh, PA
Phone: 412-386-6649
Email: cyx5 at cdc.gov


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Friday, April 28, 2006 10:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Make Folder Problem

I use the following code on my machine to create a folder and it works
fine. Just tried it on another users machine and got a message could not
create folder. I was able to do it manually. Any thoughts?

 

ChDrive "C:"

Set fso = CreateObject("Scripting.FileSystemObject")

ResultsPath = "C:\Files\Excel\Scaleup10"

 

If Not fso.folderexists(ResultsPath) Then

    MkDir "C:\Files\Excel\Scaleup10"

End If

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com