Solved

Error compiling fairly simple database

Posted on 2016-11-14
3
46 Views
Last Modified: 2016-11-14
I get an error  "Could not use (Path\filename); file already in use".  I've compiled this database (Contracts.aacdb) successfully in the past.  Don't think anything has changed as far as network/version goes (Access 2007-2013).  However, I see that  the Debug/Compile option is greyed out.  See screendumps of both the error and the VB option.   No one else is using the database.
Compile-option-not-enabled.docx
0
Comment
Question by:kerikeri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 41887112
try opening the file Contracts.laccdb and see if more than one user have the db open.
the .laccdb is located in the same folder where  Contracts.accdb is.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 41887119
Delete the .laccdb file and reboot the PC.   Do a compact and repair then try a compile

Jim
0
 

Author Closing Comment

by:kerikeri
ID: 41887126
So impressed with your quick responses.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question