OT: The Access .LDB file that will not die

2003-07-16 Thread Jim McAtee
I've got an Access 97 database that has a lock file that won't go away. I just need to delete the database file, as we've migrated the data to MySQL. The Access database is no longer being used, and I've deleted the old ODBC dsn pointing at file. I've tried the usual bad query against the db.

RE: The Access .LDB file that will not die

2003-07-16 Thread Dave Watts
I'm really trying to avoid rebooting the whole server and I'm not even certain that will do it. What about cycling IIS? I don't want to do that either unless I was fairly certain that it might do the trick. If it was locked by CF, you'll probably have better luck cycling the CF Application

RE: The Access .LDB file that will not die

2003-07-16 Thread Dan Phillips
PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:05 PM To: CF-Talk Subject: RE: The Access .LDB file that will not die I'm really trying to avoid rebooting the whole server and I'm not even certain that will do it. What about

Re: The Access .LDB file that will not die

2003-07-16 Thread Jim McAtee
- Original Message - From: Dan Phillips [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 3:06 PM Subject: RE: The Access .LDB file that will not die You can disable the DB connection in the Administrator, then delete the ldb file, then re-enable the DSN