RE: Error message "Error accessing file" in VBA Applications

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Siegfried (Siegfried_at_discussions.microsoft.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 03:49:03 -0700

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" wrote:

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

Relevant Pages

  • Re: I need some expert advice on database design
    ... What version of Access did the consultant say he worked with last? ... Using Access you can create a workable database without using or knowing ... However, depending on your organizations needs, coding VBA is suitable ... do more than just creating some macros and converting them to code. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Error message "Error accessing file" in VBA Applications
    ... the "permanent solution Microsoft is offering" is to ... > the VBA procedures. ... I created in Access2000 e.g. a database for the ... >>The VBA macros I access through Event Procedures like On Click or On Enter, ...
    (microsoft.public.access.macros)
  • Re: Merging content from access
    ... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • Re: Possible Project Bug: All Projects in Database are Deleted upon Save
    ... best practices and Project VBA ... > Only Project1 is saved into the database. ... >> prompts with Append or overwrite message. ... >> For Microsoft Project companion projects, ...
    (microsoft.public.project.vba)
  • Re: What happens when data in control is updated
    ... When I developed my concept database file I tended to look at what ... changes expected appearing on the form itself) and not going through the VBA ... > if the primary key field is Text data type, rather than numeric, the ... >>> make sure that a requery is necessary to achieve whatever your aim is. ...
    (microsoft.public.access.formscoding)