Copying an open file

Andy Brown
Andy Brown used Ask the Experts™
on
I have a development front-end that I wish to make a backup of every time I close the home screen.  However, as it is open it won't allow me to copy it.  Any ideas?

PS - It doesn't need to be pretty, as it's just for me.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
You need to write a function that opens another access application and this copies your front end...The other application will operate under timer and file operation and close after the job is completed...
Software & Systems Engineer
Commented:
Check the archive i attached...it has a FE and a backupper....nothing fancy..FE has a form1 with a button...you click the button ...the backupper  opens....it backups the file and then closes
Archive.zip
Andy BrownDeveloper

Author

Commented:
Thanks John - I'll give it a go.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial