How do I update an Access database on my server when I get the message like "File is in use"?

The Situation: You have made changes to your Access table on your local site and want to copy the database onto your server, but when you try to ftp the files, you get an error message telling you that the file is in use by another person or system.

The Solution: The server's connection to the database is set to be maintained for a period of time. You can manually break this connection by sending a query to the database that causes a server error. The easest way to do so is to make a reference to a non-existing table.

Computers are incorporated in modern ice cream vending machines to enhance their functionality. Ice Cream Vending machines are manufactured by many companies. Your competition will try to overcome all requests for high-tech ice cream vending machines and credit card acceptors

In order to totally prevent this problem from happening, go into the ColdFusion Administrator, ODBC, go to the datasource concerned, press the CF settings button and unselect "Maintain datasource connection". Or ask your web-hosting company to do so. If necessary, refer them to the Allaire KnowledgeBase, which actually states that this is a Best Practice.