Error message "Error accessing file" in VBA Applications

[Siegfried]

Dear all,
I program VBA Macros for forms in MS Access for adapting the forms to my
needs and for setting special filters by searching with DAO through the
tables extracting data as I need or counting specific items.
The VBA macros I access through Event Procedures like On Click or On Enter,
etc.
In the last time I experience more frequently the following Error Message:
"Microsoft Visual Basic"
"Error accessing file. Network connectivity may have been lost".
In this case the form becomes useless because I do not know how to repair
the fault. I'm not connected to a network. The entire Access file is on my
hard disk with all tables, forms and macros.
When T run
Tools>Database Utilities>Compact and Repair Database
nothing changes. The message stays.
My only way to overcome the fault is to develop the form again from the
scratch and program all macros again.
But even in this case I'm not sure that the fault does not repeat after a
while.
What shall I do?
I run MSAccess2000 with Windows2000 (office) and MSAccess2000 with WindowsXP
Home Edition in ann Office2000 environment.
By the way, when I open the Visual Basic Editor I can see and edit all
macros. Nothing is lost. Only the form does not find the link.
Is there somebody with a smart idea how to eliminate the fault permanently?
With regards
Sieg

--

 

[Steve Schapel]

Siegfried,

By the way, there is no such thing as VBA Macros in Access. You are
talking about VBA Procedures. Macros are something else entirely.

Please refer to http://support.microsoft.com/?id=304548 and see if this
is applicable to your situation.

 

[Siegfried]

Steve,
First of all thank you very much for your helpful hint. At least I know now
for new Access Databases how to avoid these problems with the lost link to
the VBA procedures.
But as Microsoft is aware of the problem, these procedures given in the
knowledgebase cannot be the solution.
I expect a SP or and addendum to an existing SP to overcome the problem
finally. Look here, I created in Access2000 e.g. a database for the
Transmission Assets Administration.
I developed abot 150 forms and nearly the same number of queries and a lot
of tables to present meaningful details. For this purpose I wrote some 10,000
lines of VBA code linked to complete forms (On Current) or to specific fields
for deeper evaluation of issues. The procedures are accessed through Event
Procedures linked to the fields.
When I now follow the remedy as published in the knowledge database 304548
then pratically I have to redo the database.

I must import all forms, tables, queries to a new database.
I have to disable for all forms the Has Module link to No
I have to copy and paste all VBA Modules to Text files
I have to copy and paste all VBA Modules to the VBA Editor of the new database
I have to re-open all Event procedures (more than 1000!) ........

Is this really the permanent solution Microsoft is offering???
I hope the answer will be No!
But nevertheless, thank you very much for your answer.
With regards
Siegfried

 

[Steve Schapel]

Siegfried,

As I understand it, the "permanent solution Microsoft is offering" is to
install Service Pack 3. The steps you are being asked to take are not a
solution in that sense, they are in order to recover your specific
project from an already damaged state.

 

[Siegfried]

Steve,
I got that meanwhile, too. I installed Office SP3 and I got now a different
version of the dll Vbeb6. So I think the bug is solved now on my system.
But the re-make of my larger Access Database is still outstanding. That is a
burden because I hate doing things twice. But what shall I do else?
The most important thing is that I got with your help a solution for my
problem.
Thanks again.
With regards
Siegfried

 

[¹Ú¹®¼ö]

Dear all,
I program VBA Macros for forms in MS Access for adapting the forms to my
needs and for setting special filters by searching with DAO through the
tables extracting data as I need or counting specific items.
The VBA macros I access through Event Procedures like On Click or On Enter,
etc.
In the last time I experience more frequently the following Error Message:
"Microsoft Visual Basic"
"Error accessing file. Network connectivity may have been lost".
In this case the form becomes useless because I do not know how to repair
the fault. I'm not connected to a network. The entire Access file is on my
hard disk with all tables, forms and macros.
When T run
Tools>Database Utilities>Compact and Repair Database
nothing changes. The message stays.
My only way to overcome the fault is to develop the form again from the
scratch and program all macros again.
But even in this case I'm not sure that the fault does not repeat after a
while.
What shall I do?
I run MSAccess2000 with Windows2000 (office) and MSAccess2000 with WindowsXP
Home Edition in ann Office2000 environment.
By the way, when I open the Visual Basic Editor I can see and edit all
macros. Nothing is lost. Only the form does not find the link.
Is there somebody with a smart idea how to eliminate the fault permanently?
With regards
Sieg