Problem overwriting MS Access Database

I want to overwrite the file for my Access Database but an error prevents it. My webhost technical support says the the database is open and that is why I can't overwright it. They tell me that the script is supposed to close the database but I had this issue before and expert exchange helpers explained to me that the database is open and closed by the server and not the script. The webhost technical support tells me as long as the .lbd file exists, the database is open. I have tried to delete this file but am not able to. Can someone help me figure out why I can't overwright my database file?
Thanks!!!
ktjamms2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DanielSKimCommented:
There are two solutions that seemed to have worked for others:

http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_10674061.html?query=coldfusion+ldb&topics=112
- create two mdbs, one with data, one that has tables linked (not imported)
- set the mdb that is linked to the other as your datasource
- the mdb with the data is then always unlocked and you can always replace it

http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20894164.html?query=coldfusion+ldb&topics=112
- create an page with an erroneous query
- run the page, and it seems to unlock the mdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
8riaNCommented:
Excellent suggestions from DanielSKim.

Just FYI, the database is open because the CFAdministrator is set to cache database connections.  There is a setting for how many minutes to cache them, so if all else fails, you can deactivate the site's data access and wait for the timeout, or get the host to restart the CFServer and the database will be unlocked.  As you can see, DanielSKim's methods are much preferable.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.