Copying the .mdb file

[Jamessh]

Hi, I have a coldfusion server running a webapp that uses an access database. It is hosted on a secure server and I only have ftp rights.

My problem is this:
I want to automate a backup on our servers of this database.
I created a java program to ftp the file down but I didnt have rights so I checked into it and while the webapp is using the database I cannot copy the .mdb file.

I did some research and found that if you use access to open the .mdb and use exclusive you can then copy the .mdb, shared you cannot.

Is there a way I can connect to this .mdb file( I am just connecting through a datasource ) so that I can copy the .mdb at will?

Thanks in advance

 

[ghudson]

Check out the link below for the code I posted to copy a database [while it is opened], zip it up, and move that copy to another location.
http://www.access-programmers.co.uk/forums/showthread.php?t=57863

 

[Jamessh]

Thank you for your post but I dont know much about this server and have never worked with VB(I assume that is what language you are using) so I dont know how to run a scheduler with it as I wanna automate this process The only thing I have is ftp access.

I did check into datasources and found an option to open them exclusive, maybe I can call the company and have them switch it to open exclusive if all else fails