Access 2000 error ... occasionally

[robert]

I've got xp professional w/ service pack 2, using access 2000 (never
updated) and I recently ran into a problem - I believe it's stemming
from command buttons. I added a button where on click it simply
previews a report and it seemed to be working fine, when suddenly I
receive some type of 'unable to connect to server' error and command
buttons on every form in the database go unusable, and I receive
failures and errors when trying to add them or trying to use them.

I ended up importing all my tables, queries and reports into a new
database and designing completely new forms and of course, everything
worked fine....for a few hours until the error appeared again. On
error it takes you to the modules/vb screen (ctrl-g) but I have no
idea why this is happening or how to fix it.

Sound familiar to anyone? I've created about 4 new databases since
Monday and I'm waiting for the errors to appear again, as soon as they
do I'll post the actual error messages.

Thanks in Advance!

 

[Bill Mosca, MS Access MVP]

This might be caused by a known bug in 2000. Have you installed Service
Release 1a? Tahat fixes a dll conflict with VB6 which corrupted the database
files.

 

[Tony Toews [MVP]]

when suddenly I
receive some type of 'unable to connect to server' error

Please post the exact error message.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/