How to rename a file from within access?

D

ddevico

We are using access 2000 to add a report to many mobile
user copies of our dbase. We plan on using a small dbase
file that will autoexec (with dbase window hidden on
startup so it is transparent) and transferDatabase the new
report/querys in, send an email back to us that it was
accomplished (still working on that--errors).

Anyway, we also need to rename a file in the directory
where their dbase resides (a bin file). Is there any way I
can accomplish that from within this access dbase as well?

Thanks for any info.
 
R

Rick Brandt

ddevico said:
We are using access 2000 to add a report to many mobile
user copies of our dbase. We plan on using a small dbase
file that will autoexec (with dbase window hidden on
startup so it is transparent) and transferDatabase the new
report/querys in, send an email back to us that it was
accomplished (still working on that--errors).

Anyway, we also need to rename a file in the directory
where their dbase resides (a bin file). Is there any way I
can accomplish that from within this access dbase as well?
Click to expand...

From Access Help file:
Name Statement
Renames a disk file, directory, or folder.

Syntax
Name oldpathname As newpathname
 
D

ddevico

-----Original Message-----
well?

From Access Help file:
Name Statement
Renames a disk file, directory, or folder.

Syntax
Name oldpathname As newpathname


.
Click to expand...
 
Top