How to rename a Database file

[mota]

Hi;
After i compacted a BackEnd DB to a new one,i have to kill the old
DB(Uncompacted) and then rename the new made DB to its default name(the name
of uncompacted DB) so that the front end can reconnect to it.How can i
rename a file (e.g a mdb file) thru code in access 2000?
Thank you for your help in advance.

 

['69 Camaro]

Hi.

Use the Name command to rename the file:

Name sOrigFileName As sNewFileName

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Mota]

Thank you for the useful and easy tip.Its not included in VBA help file in
access.Where can i find such a commands to work with files and folders in
VBA?
Thank you.