Error message "Error accessing file" in VBA Applications

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
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
 
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.
 
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
 
Siegfried said:
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
Click to expand...
 
Back
Top