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?

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 wrote:

Chris O'C wrote:
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?

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

Chris


TraciAnn wrote:
Show quoteHide quote

Owner - Full Rights

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 wrote:

Chris,

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


Yes. Same problem.

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

No problems with this one.

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

Thanks again Chris.

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 wrote:

This worked!

Thanks Chris!

Access Networking & Security Issue.
Problem deleting records - Access XP and our intranet
IGNORE SECURITY!
Access 2007 -> /pwd -> how to work around?
Project is Unviewable
Objects Security Permission
Read-Only Database!
Need Help With Security
After migrating .mdb to v.2007 & rename mdw file, v.2007 lets me i
Upgrade a password protected database