Tags: access, associated, c-drive, cant, database, delete, file, ive, ldb, lock, microsoft, mysql, oracle, sql, todelete

cannot delete Access 97 file

On Database » Microsoft Access

4,432 words with 4 Comments; publish: Fri, 30 May 2008 19:45:00 GMT; (25093.75, « »)

I've got a database file on my C-drive that I can't delete. I was able to

delete the associated lock (ldb) file fine but if I try to make any changes

to the file itself (delete, rename, move, compact and repair it, etc) it

won't let me, telling me that someone else has exclusive access to the file.

I've checked that I have no other applications reading the database (such as

Excel) and have rebooted in case there's something running I can't see in

Task Manager.

Does anyone have any ideas how I can get rid of this thing?! I need to

replace it with a newer version and it won't let me.

All Comments

Leave a comment...

  • 4 Comments
    • Try rebooting the computer.

      That should release any open connections.

      Allen Browne - Microsoft MVP. Perth, Western Australia

      Tips for Access users - http://allenbrowne.com/tips.html

      Reply to group, rather than allenbrowne at mvps dot org.

      "Smallweed" <Smallweed.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:BCDF1544-E14B-435C-B372-CA9F1C90E2D3.ms-access.questionfor.info.microsoft.com...

      > I've got a database file on my C-drive that I can't delete. I was able to

      > delete the associated lock (ldb) file fine but if I try to make any

      > changes

      > to the file itself (delete, rename, move, compact and repair it, etc) it

      > won't let me, telling me that someone else has exclusive access to the

      > file.

      > I've checked that I have no other applications reading the database (such

      > as

      > Excel) and have rebooted in case there's something running I can't see in

      > Task Manager.

      > Does anyone have any ideas how I can get rid of this thing?! I need to

      > replace it with a newer version and it won't let me.

      #1; Fri, 30 May 2008 19:46:00 GMT
    • Doesn't help unfortunately. I guess the file must be corrupted (it's an

      Access 97 replica and I know these are prone to getting bloated and

      corrupted!).

      "Allen Browne" wrote:

      > Try rebooting the computer.

      > That should release any open connections.

      > --

      > Allen Browne - Microsoft MVP. Perth, Western Australia

      > Tips for Access users - http://allenbrowne.com/tips.html

      > Reply to group, rather than allenbrowne at mvps dot org.

      > "Smallweed" <Smallweed.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      > news:BCDF1544-E14B-435C-B372-CA9F1C90E2D3.ms-access.questionfor.info.microsoft.com...

      >

      #2; Fri, 30 May 2008 19:47:00 GMT
    • Exactly what message do you receive when you try to delete it?

      Are you logged in to Windows as a local computer adminsrator?

      Can you delete the file if you boot Windows in safe mode?

      Try runnind Scandisk (or Chkdsk) to see if you have crosslinked files on

      your drive.

      Allen Browne - Microsoft MVP. Perth, Western Australia

      Tips for Access users - http://allenbrowne.com/tips.html

      Reply to group, rather than allenbrowne at mvps dot org.

      "Smallweed" <Smallweed.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:26998DF0-E9B5-4E0A-AAA7-9FE2243A9078.ms-access.questionfor.info.microsoft.com...[vbcol=seagreen]

      > Doesn't help unfortunately. I guess the file must be corrupted (it's an

      > Access 97 replica and I know these are prone to getting bloated and

      > corrupted!).

      > "Allen Browne" wrote:

      #3; Fri, 30 May 2008 19:48:00 GMT
    • They sound good suggestions: thanks, I'll give them a go.

      "Allen Browne" wrote:

      > Exactly what message do you receive when you try to delete it?

      > Are you logged in to Windows as a local computer adminsrator?

      > Can you delete the file if you boot Windows in safe mode?

      > Try runnind Scandisk (or Chkdsk) to see if you have crosslinked files on

      > your drive.

      > --

      > Allen Browne - Microsoft MVP. Perth, Western Australia

      > Tips for Access users - http://allenbrowne.com/tips.html

      > Reply to group, rather than allenbrowne at mvps dot org.

      > "Smallweed" <Smallweed.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      > news:26998DF0-E9B5-4E0A-AAA7-9FE2243A9078.ms-access.questionfor.info.microsoft.com...

      >

      #4; Fri, 30 May 2008 19:49:00 GMT