object invalid or no longer set

[TSanders]

Hello everyone, I hope someone here can help. I created an application in
MSAccess 2000 using VBA for a local telco to track their DSL orders. The
database is split into a front end and a back end. There are approximately
60 users. 4 of the users receive the error "Object invalid or no longer
set" at random times while they are using the application. After trying all
the suggestions on Microsoft's site, the error is still occurring.
Yesterday, we gave one of the troubled users a new machine and the error no
longer occurs for that user. I cannot find a common denominator for the
other 3 users. 2 are using Windows XP, one is on Windows 2000. One is
using Office 2000, one is using Office XP, and one is using Office 2003.
All the machines have at least 256 megs of ram and are pentium 4 class.
Please offer any suggestions you may have. Thank you.

Tammy

[Allen Browne]

For this kind of intermittent error, the first thing to check would be
service packs.

The Help | About in Access will show you the service pack. You should see
SP3 for Access 2000, SP3 for Access 2002, and SP1 for Access 2003.

More importantly, is the JET service pack. Locate the file msjet40.dll
(typically in windows\system32). Right-click, and choose Version, You should
see 4.0.8xxx.0. If you do not see the 8, you need SP8 for JET 4.

The service packs are available in the Downloads section at
support.microsoft.com. I would expect the JET 4 service pack to solve the
problem.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TSanders" <ju*******@triad.rr.com> wrote in message
news:7x****************@twister.southeast.rr.com.. .

Hello everyone, I hope someone here can help. I created an application in
MSAccess 2000 using VBA for a local telco to track their DSL orders. The
database is split into a front end and a back end. There are
approximately
60 users. 4 of the users receive the error "Object invalid or no longer
set" at random times while they are using the application. After trying
all
the suggestions on Microsoft's site, the error is still occurring.
Yesterday, we gave one of the troubled users a new machine and the error
no
longer occurs for that user. I cannot find a common denominator for the
other 3 users. 2 are using Windows XP, one is on Windows 2000. One is
using Office 2000, one is using Office XP, and one is using Office 2003.
All the machines have at least 256 megs of ram and are pentium 4 class.
Please offer any suggestions you may have. Thank you.

Tammy

[TSanders]

Thanks Allen, I will try your suggestion.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

For this kind of intermittent error, the first thing to check would be
service packs.

The Help | About in Access will show you the service pack. You should see
SP3 for Access 2000, SP3 for Access 2002, and SP1 for Access 2003.

More importantly, is the JET service pack. Locate the file msjet40.dll
(typically in windows\system32). Right-click, and choose Version, You should see 4.0.8xxx.0. If you do not see the 8, you need SP8 for JET 4.

The service packs are available in the Downloads section at
support.microsoft.com. I would expect the JET 4 service pack to solve the
problem.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TSanders" <ju*******@triad.rr.com> wrote in message
news:7x****************@twister.southeast.rr.com.. .

Hello everyone, I hope someone here can help. I created an application in MSAccess 2000 using VBA for a local telco to track their DSL orders. The database is split into a front end and a back end. There are
approximately
60 users. 4 of the users receive the error "Object invalid or no longer
set" at random times while they are using the application. After trying
all
the suggestions on Microsoft's site, the error is still occurring.
Yesterday, we gave one of the troubled users a new machine and the error
no
longer occurs for that user. I cannot find a common denominator for the
other 3 users. 2 are using Windows XP, one is on Windows 2000. One is
using Office 2000, one is using Office XP, and one is using Office 2003.
All the machines have at least 256 megs of ram and are pentium 4 class.
Please offer any suggestions you may have. Thank you.

Tammy