• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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

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.
Fletcher Burdine
Fletcher Burdine
2 Solutions
Kelvin SparksCommented:
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
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?
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now