We have a ColdFusion web application that uses an MS Access database. Once in a while when I open the database to fix data, which shouldn't need to be done but the way it was written it's currently the only way, the website will go down. I've had it open for hours removing profiles that are years old and nothing happens but ever so often the site goes down. What is the alternative to doing this? The IT Manager said to move the database to the Desktop to make the changes then copy it back over to Production. But I said that this will then overwrite all the inputs made to the Production db during that time. The use of the database is 24 hrs a day. Is Replication something I could consider?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.