Access Error when I open an Access VB developed application and modify a field type in design view using the Lookup Wizard.

Posted on 2011-04-25
Last Modified: 2012-05-11
I cannot seem to save my work or add lookup windows to the table I am trying to build. I get the following error every time I go into the field type and try to select the Lookup Wizard. If you know why or how this could be happening please let me know.

I am the only person logged into the Access database and I am the only person logged into the machine. Any support is greatly appreciated.

 Thank you.
Question by:ruavol2
    LVL 22

    Accepted Solution

    Ensure that you (even if the only user) open the database in exclusive mode. Depending on the version you are using it can be fifferent to find. In Access 2003 , start Access, then do filre open, and make sure you select open exclusive at the bottom right fbefore you select the file to open
    LVL 77

    Assisted Solution

    Close the database and Access.
    Check in the folder containing the accdb file to see if there is a file called yourdatabasename.laccdb ( Access Record-Locking Information file).  If there is , delete it and then re-open your database and try again.

    If not, do you get a read-only warning if you open a table in design view?

    Author Closing Comment

    Both of those ideas worked. Sorry for the delay where I live was hit by tornado and my actual internet substation was destroyed. They have been rebuilding it and the internet has been spotty not to mention all the times they turned power off on me. Thank you for the help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    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…
    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…
    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 …

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now