Persistent IDB in Access 2007

[WinDancer]

There are 4 folks having the same problem, all in different DBs-
The IDB files will not go away.
Can't delete them.
Can't rename them.
Can't move them.

Any ideas? None of us has ever seen this with Access.

Thanks,
Dave

 

[Alisa]

What's an IDB?

 

[WinDancer]

Access sets up an IDM temp file when you open a database to prevent anyone else from changing any code while they have it open. It essentially 'locks' the code and protects it.
The file is supposed to be deleted as users close the database.
It is not doing that here at work- four different users, a couple of dozen different databases.
We are unable to even compact the DBs- it says you can't, another user has it open.
When you go read the IDB file it is me that has it open, but it still won't allow the conpact to occur.
I was hoping this was one of Bill's new 'features' and that someone else had already founf a work-around.
Nothng here and nothing at Microsoft and nothing on Google.

 

[Alisa]

Oh, you mean ldb.

Sounds like something weird is going on when the database is closing. Is there code in the on close event of the main menu or something?

 

[WinDancer]

Yup- a typo in my last post

 

[Alisa]

Its L not I though.

 

[boblarson]

Access sets up an IDM temp file when you open a database to prevent anyone else from changing any code while they have it open. It essentially 'locks' the code and protects it.
The file is supposed to be deleted as users close the database.
It is not doing that here at work- four different users, a couple of dozen different databases.
We are unable to even compact the DBs- it says you can't, another user has it open.
When you go read the IDB file it is me that has it open, but it still won't allow the conpact to occur.
I was hoping this was one of Bill's new 'features' and that someone else had already founf a work-around.
Nothng here and nothing at Microsoft and nothing on Google.

Normally that happens if someone doesn't have delete rights to the folder in which the LDB file is located.