Update a datasource

My site (written by someone else) runs off Access db.

I downloaded this file via ftp, made changes, and now want to upload it and replace the other.

I cannot do this, as the "file is in use". Is ther any way to tell Access to close the db, so i can uplaod the new db ?

Thanks

-Matt

This is a problem with file-based databases. I believe you can write a simple SQL query that will throw an error like

<cfquery dsn="myAccessDSNName">
select * from blahfootabledoesntexist
</query>

which will generate an error and should cause the database connection to close. Then you can quickly upload the new file but you have to do it before another valid query runs which will create a new connection.