Here is a technique for that ... I used to use it to unlock access database from remote server so that I could upload an updated database file:
Basically if you write a script that queries the database but causes a database error, it will unlock the file. So you could put in a cfquery tag that say tries to get data from a table or column that does not exist which will of course throw an error. Then implement some code to handle the error gracefully. This may or may not work for your situation and you will have to experiment with it a bit. Dusty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 22, 2007 1:34 PM To: [email protected] Subject: RE: [ACFUG Discuss] MS Access Issue The problem appears to be that the record locking file (*.ldb) is being left when the user closes the database. When the file is first put out on the server (no ldb file exists) the file opens just fine (no message). But closing the file does not delete the ldb file as it should when the last person who has the file opened closes the database. Because this ldb file is still out there on subsequent attempts, it appears to MS Access that there is a user that still has the file open - the question now is why, when opening the database through CF does the ldb file not get deleted once the database is closed. Craig Nassal Federal Reserve Bank of Atlanta 1000 Peachtree St. N.E. Atlanta, Ga 30309-4470 (404)498-8437 [EMAIL PROTECTED] "Dusty Hale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/22/07 10:16 AM Please respond to [email protected] To <[email protected]> cc Subject RE: [ACFUG Discuss] MS Access Issue Something tells me you should try some other way than cflocation to open it. I tried it and it seems buggy where just a clickable link to it opens fine with no message like the one you describe. This is just my instinct though so I don't know if that is the real issue or not. D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 22, 2007 10:02 AM To: [email protected] Subject: Re: [ACFUG Discuss] MS Access Issue We are giving the user access to the database on the file system - this purpose of this app is to better organize all of the various files this department uses - information pertaining to the file (name, subject matter expert, etc) is displayed and there is a "launch" button to open the file in it's native app (like ms access or excel)..... Craig Nassal Federal Reserve Bank of Atlanta 1000 Peachtree St. N.E. Atlanta, Ga 30309-4470 (404)498-8437 [EMAIL PROTECTED] "Teddy R Payne" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/22/07 09:37 AM Please respond to [email protected] To <[email protected]> cc Subject Re: [ACFUG Discuss] MS Access Issue What is your intent for the user to be able to do? Are you giving them access to the database on the file system or do you want them to just query the database? Teddy ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, June 22, 2007 7:51 AM Subject: [ACFUG Discuss] MS Access Issue >I have a CF App that is attempting to open an MS Access Database - when > Access is opening the file, the following message is produced: "You do not > have exclusive access to the database at this time. If you proceed to > make changes, you may not be able to save them later.". I've verified > that there is no other users opening the file or working with the file in > any way when this occurs. It does appear that a record locking file is > created when the user opens the file through the app. They are able to go > directly to Access and open the file successfully without the message, so > it appears that the issue is the way that I'm opening the file through CF > - I'm just using a cflocation to open the file. Has anyone experienced > this issue and know how to open the file without getting this message? > > Thanks for in advance for the help. > > Craig Nassal > > Federal Reserve Bank of Atlanta > 1000 Peachtree St. N.E. > Atlanta, Ga 30309-4470 > (404)498-8437 > [EMAIL PROTECTED] > > > ------------------------------------------------------------- > Annual Sponsor FigLeaf Software - http://www.figleaf.com > > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
