You have a few options:
1) Go into the CF Administrator (if you have access to that) and hit the
Relase button on the Verify Data Source page. Now your MDB should be
closed (no more LDB) and you can overwrite it.
2) There's an undocumented function (CFUSION_DBCONNECTIONS_FLUSH()) that
will do what that button does, even without CF Admin access (gotta love
CF security, but anyways...).
3) Upload a new DB w/ a new name & change your datasource to point to
it.
Number 3 is the best because if anything hits your database and tries to
change it while you're uploading it, BadThings can happen. You best bet
(IMHO) is to upload a new DB with a different name (numbering them
sequentially is pretty sensable), change the datasource to point to your
new DB, flush the connections using 1 or 2 above, then delete the
original DB.
Hope that helps!
Best regards,
Zac Bedell
-> -----Original Message-----
-> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
-> Sent: Thursday, May 03, 2001 12:54 PM
-> To: CF-Talk
-> Subject: Access ldb files w/a twist
->
->
-> So, here is my question and basically it's a problem.
->
-> Now when you open any Access file you get that little
-> annoying ldb file with
-> it, it closes no problem if you're working with Access
-> directly however what
-> if the Access file is on a server and you don't have access
-> to it directly?
->
-> What if I need to replace that database with a new one (and
-> that stupid ldb
-> file won't go away)?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
