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

Access 2003 - Rename or Copy File Problems

P: n/a
I'm trying to rename a shared network file after uploading the data
using an import data specification.

I tried using NAME oldfilename AS newfilename and got the generic
"File not found" message. Tried Filecopy using a DECLARE FUNCTION and
it could not locate MSAU200.dll file.

Does anyone know how to do this in Access 2003? If you have any code
samples, I'd appreciate it.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ano1optimist wrote:
I'm trying to rename a shared network file after uploading the data
using an import data specification.

I tried using NAME oldfilename AS newfilename and got the generic
"File not found" message. Tried Filecopy using a DECLARE FUNCTION and
it could not locate MSAU200.dll file.

Does anyone know how to do this in Access 2003? If you have any code
samples, I'd appreciate it.


Are you supplying the path to the file? Ex:
Name "C:\Test\TestFile.Txt" As "C:\Test\TestFile1.Txt"
Nov 13 '05 #2

P: n/a
Yes, I am supplying the path name. I could not get the NAME function
to work. I was able to get the FILECOPY function to work though. Not
sure why I had the problem, but a good night sleep also helps.
Nov 13 '05 #3

P: n/a
ano1optimist wrote:
Yes, I am supplying the path name. I could not get the NAME function
to work. I was able to get the FILECOPY function to work though. Not
sure why I had the problem, but a good night sleep also helps.


Name is a built-in statement in VBA and should work with every version
of Access. Is it possible you didn't have the " AS " clause between
the source and destination?

Name "c:\temp\file1.txt" AS "c:\temp\file2.txt"

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.