Error Message

[Caroline Bycroft]

i have created a database and the forms and tables are
split. The forms have been placed on two computers and
linked to the data that is held on only one of the
computers. This morning one of my customers asked me if i
could make a change to a form and a report that should of
been very easy. However, when I went into the coding of
the form that needed amemding i found that i could not
amend any of the code without generating an access error
message. This message read as follows: Error accessing
file, network connection may have been lost.
The amendments that i had just made would then revert back
to its original state. I have never seen an error like
this and i have never had coding change back to its
original state when you have made changes. Has anybody
ever encountered an error like this and if so do they know
what or how it is generated.

 

[Ayala]

Hi,
I never experienced your problem... but later I read a
similar post. Here is a copy paste of the message on Nov
17 2:00am on Active X Control Group. Hope it helps you.
best regards,
Ayala

===============POST==============================
Just regarding the error message "network connection ...".

I suspect this is the same error that I received in v2000
databases...error message as:
"Error accessing file. Network connection may have been
lost."
Refer to Microsoft Knowledge Base Article - 304548.

Essentially this error occurs when vb code from one V2000
database is copied to another V2000 database. But it
also seems to occur on occasions when forms (with VB
code) are copied from one V2000 database to another.
Unfortunately the database is corrupt after this occurs,
and when trying to compile, or run the affected modules,
the above error will be displayed.

There is a patch to download (see article). However, as
a prevention, I always copy databases under development
VERY!! regularly

Trust this helps.

Regards LB