Solved

Error compiling fairly simple database

Posted on 2016-11-14
3
48 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 58

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

691 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