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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 08/09/04 

Date: Tue, 10 Aug 2004 06:22:07 +1200

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 Schapel, Microsoft Access MVP
Siegfried wrote:
> 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 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, ... > My only way to overcome the fault is to develop the form again from the ...
    (microsoft.public.access.macros)
  • Re: Database Locks when Form is Opened
    ... I figured out the VBA code needed below, but that did not fix the problem with opening the frm_ReportDialog when moved to another machine. ... I am now recreating those two forms, queries and macros, in a new database. ... >> End Sub ...
    (microsoft.public.access.formscoding)
  • RE: Macro Language
    ... couldn't I use macros. ... > This can be done through VBA macro code but it could get messy. ... > you allude a database of accounts. ...
    (microsoft.public.excel.programming)
  • 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)