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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

777 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