How to rename a file from within access?

  • Thread starter Thread starter ddevico
  • Start date Start date
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.
 
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?

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

Syntax
Name oldpathname As newpathname
 
Back
Top