error 91 in VBA in Access XP 2003

  • Thread starter Thread starter Naturtle via AccessMonster.com
  • Start date Start date
N

Naturtle via AccessMonster.com

I have an access 2000 MDE database which is in use by several clients on
varying levels of Windows and Office configurations. Recently two of my
clients have upgraded to Access 2003 under XP 2003. Now they are
experiencing intermittent "Error 91 Object Variable or with block variable
not set". The message comes up at varying places and is unreproduceable by
them or me. Has anyone seen anything like this?
 
This is a programming error due to either a object variable that has not
been properly initialized, or possibly a conditional or looping structure
where the syntax is incorrect.

I would try to use the debugger to step through the code to find the error.
When the user experiences the problem, have them note exactly what they were
doing when they encountered the issue. This will make it easier to locate
the issue.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


message I have an access 2000 MDE database which is in use by several clients on
varying levels of Windows and Office configurations. Recently two of my
clients have upgraded to Access 2003 under XP 2003. Now they are
experiencing intermittent "Error 91 Object Variable or with block variable
not set". The message comes up at varying places and is unreproduceable by
them or me. Has anyone seen anything like this?
 
.....or, get into the habit of including error handling with each procedure
that logs a record for each error into a table so you don't have to rely on
the user to tell you where it is breaking...
 
Back
Top