Share via

recovering from ms access error object variable or with block variable not set

Anonymous
2016-10-21T12:27:09+00:00

I just opened a database that I was working on yesterday and by working I mean running queries, etc. no programming changes. I connected from my laptop to a database on the server to update a table and then when I went to close out I got this:

"Object variable or with block variable not set"  The error appeared right after an error about a missing table, which I am pretty sure is not missing!  I could not get out of this error and had to use task manager to shut down Access.  Now, every time I open the database I get the same results.  How do I get into the database to see what is going on?  Thanks.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2016-10-21T14:06:39+00:00

    Hold down the Shift key while opening the FE, so the AutoExec macro does not run.

    You can also hit Ctrl+Break when the error is up, and break in the debugger.

    I talk about this technique in my debugging video https://www.youtube.com/watch?v=rfI311gfTCA

    Was this answer helpful?

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-24T13:20:43+00:00

    thanks

    Was this answer helpful?

    0 comments