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!

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.

--
Bill Mosca, MS Access MVP
http://tech.groups.yahoo.com/group/M..._Professionals


"robert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>

robert <(E-Mail Removed)> wrote:

>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/