Unable to compact/repair because I have it opened

[TraciAnn via AccessMonster.com]

Hello (again)

ac'07

I'm seeing signs of corrupt data so I'm trying to compact/repair my backend.
(That could have a double meaning <lol> )

Although everyone is logged out and I am the only one accessing it, I get an
error message saying the file is exclusively in use by {MyUserName} on
{MyMachine}.

All users were definitely logged out. I wasn't running a FE. The .mdw is in
the same folder as the BE. I tried both with the file open and also with the
file closed (with just access open>>Manage>>Compact/Repair then select BE
file).

Any ideas?

 

[Chris O'C via AccessMonster.com]

If the mdb file and mdw file have the same base name (like products.mdb and
products.mdw), they share the same locking db (ldb) file. To avoid that,
either rename one of them or move one of them to a different folder so they
each have a separate ldb file.

Chris

 

[TraciAnn via AccessMonster.com]

If the mdb file and mdw file have the same base name (like products.mdb and
products.mdw), they share the same locking db (ldb) file. To avoid that,
either rename one of them or move one of them to a different folder so they
each have a separate ldb file.

Chris

Chris,

I use a naming convention of:
..\App\dbName.mdb
..\App\dbName.mdw
..\Store\dbName_BE.mdb

The App\dbName.mdb is copied to local workstations by AutoFE, so the mdb in
the App folder is not in use.

Since I'm trying to Compact/Repair ..\Store\dbName_BE.mdb the ldb files would
be different names and different folders.

Any other ideas?

 

[Chris O'C via AccessMonster.com]

What are your Windows permissions on ..\Store\ where the backend is stored?

Chris

 

[TraciAnn via AccessMonster.com]

Owner - Full Rights

 

[Chris O'C via AccessMonster.com]

Things to check:

1 - Open the backend in Access. Click on the Office button (top left), then
Access Options > Advanced. Scroll down to the advanced section. Make sure
default open mode is shared, not exclusive. Click ok button to close, saving
changes to settings. Try to compact the db. Same problem?

2 - Do you have any special ribbons or add ins in the backend? Like the
Adobe pdfmaker toolbar?

3 - Open notepad and create a new text file in the same folder as the .\Store\
dbName_BE.mdb file. Add any text. Save it. Add more text. Save it again.
Close notepad. Delete the text file you just created and modified. Any
problems?

Chris

 

[TraciAnn via AccessMonster.com]

Chris,

Thanks for the detailed list; response in line...

1 - Open the backend in Access. Make sure default open mode is shared, not exclusive. Click ok >button to close, saving >changes to settings. Try to compact the db. Same problem?

Yes. Same problem.

2 - Do you have any special ribbons or add ins in the backend? Like the
Adobe pdfmaker toolbar?

Yes. I have Adobe Acrobat toolbar. It is default with our corporate ws image.

3 - Open notepad and create a new text file in the same folder as the .\Store\
dbName_BE.mdb file. Add any text. Save it. Add more text. Save it again.
Close notepad. Delete the text file you just created and modified. Any
problems?

No problems with this one.

Interested in hearing what conflict Adobe creates and how to fix.

Thanks again Chris.

 

[Chris O'C via AccessMonster.com]

Disable the Access component of the Adobe Acrobat toolbar, but leave it
intact for the other Office programs. It makes a design change to the db
file whenever it opens, requiring exclusive access to the file.

Chris

 

[TraciAnn via AccessMonster.com]

This worked!

Thanks Chris!