Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Problem overwriting MS Access Database

Posted on 2005-03-29
Medium Priority
Last Modified: 2013-12-24
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?
Question by:ktjamms2
LVL 15

Accepted Solution

DanielSKim earned 500 total points
ID: 13653393
There are two solutions that seemed to have worked for others:

- 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

- create an page with an erroneous query
- run the page, and it seems to unlock the mdb

Assisted Solution

8riaN earned 500 total points
ID: 13653658
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.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Screencast - Getting to Know the Pipeline
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question