Can't upload revised database

[outdoorsgal]

I'm trying to upload a revised Access mdb file to our server. There is an ldb
file present almost all the time because we have 6K+ users worldwide and
someone is always using the database. I'd like to force the database to close
so I can upload the new file. What can I do?

[paross1]

First of all, the Maintain Connections attrribute in your Access data source
configuration should be unchecked. Also, you should have a means to temporarily
disable your web site, or at least, the pages that access the database, so that
you can freely update your database file when you are guaranteed single user
access. I have a variable that I can set in application.cfm that will refirect
users to a "trmporarily disabled for maintenance" page while I am doing this
sort of maintenance,. Or, for a quick and dirty way, just place a <CFABORT> tag
at the head of your application.cfm and your entire site will be disabled.

Phil

[outdoorsgal]

Phil,

I disabled the website at 10:30 this morning ( 2 hours ago) and still can't
upload a new data file. How do I disable Maintain Connection in the data
source? I'm getting desperate. Thanks for your help.

Jan

[paross1]

In your ColdFusion Administrator, you would have to select your data source and the advanced settings to see this particular attribute, then un-select it.

[outdoorsgal]

:D Thanks for your help!!! Works great now!

[CoderGuy]

Here's an easy way that has always worked for me and does not involve changes
in the CF Administrator (which sometimes you might not have access to). This
breaks the DSN connection to your database and removes the Access .ldb file so
you can overwrite the database: <CFSET
temp=CFUSION_DISABLE_DBCONNECTIONS('#DSN#', 1)> Of course, don't forget to
re-enable the DSN when you're done: <CFSET
temp=CFUSION_DISABLE_DBCONNECTIONS('#DSN#', 0)>

[paross1]

Does CFUSION_DISABLE_DBCONNECTIONS still work with MX? The only reference that
I have found for this is as an added administrative function for CF 4.5.

[url]http://www.macromedia.com/support/documentation/en/coldfusion/45update.html[/url]

Phil