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
Medium Priority
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

Kelvin Sparks earned 1000 total points
ID: 35464638
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

peter57r earned 1000 total points
ID: 35464907
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

ID: 35738300
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

621 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