Errors and erros

[Mark A. Sam]

Hello,

My clients are encountering errors on applications which have been in place
for years, and seem to be increasing as I make changes. The errors are
unrelated to the changed, for example if I change the caption on a label the
form bombs out. This is happening on different sites on several
applications.

I kind of think this may be an operating system issue. These are systems
running Windows 2000 Server. On system is running Access 2k the other
Access2002. On has SQL Server as a back end for one app and Access as the
back end for another. The other has Access as the back end.

There is no consistency to the errors where I can debug and find the cause.
Each app has different issues.

Is anyone else encountering new unexplained errors? Could they be related
to Windows updates or another external cause?

Thank you for any help and God Bless,

Mark A. Sam

 

[Rob Oldfield]

Have you recently switched the data files to a different server? I had an
issue a while ago where we installed a new 2000 file server and switching
databases onto it made them fall over intermittently. (The solution was to
tweak a registry setting which might have performance implications on other
files, so I ended up making that tweak on a different server and now base
all Access databases there.)

If that is the case, then what error are you getting? (...as I can't
remember enough about the error to find a reference to it now....)

 

[Mark A. Sam]

Hello Rob,

None of the DBs are on new servers. The biggest problem on the SQL Server
app is ODBC errors which occur intermittently. I can't duplicated them
which makes it difficult. This is a very complex form with layers of
subforms. The subforms weren't updating the ChildLinkFields and I thought I
figured out work arounds, but the the ODBC keep popping up without reason.

File locking seems to be an issue on another app. It is a quoting system
and emails out a quotes using SendObject. It recalulated the quote and
replaces values in the DB before sending the email. If another user is on
the record, it locks the fields preventing updates and causing a bunch of
errors. It seems to be a problem for this Database only. It is Access2K
with an Access2k back end. Also, sometimes the system hangs up before the
email comes up in edit mode, and sometimes it closes Access. Its goofy. If
I am able to duplicate the problem then set up breaks for debugging in the
code, then it works fine.

Sometimes I think these programs are made to self destruct after a while so
we buy updates.

God Bless,

Mark

 

[Rob Oldfield]

The errors that I was talking about were related to record locking. What
error(s) do you get?

Haven't got a clue about the ODBC I'm afraid.