Backup current access file using vba while the file is open

[jack1080]

Backup current access file using vba while the file is open

I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?

I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.

 

[Remou]

You can use the FileSystemObject Object.

 

[jack1080]

Thanks, that worked! I am wonder why filetocopy cannot work while filesysemobject able to do the job...