Microsoft Visual Basic For Applications Error Accessing File
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 15:30:19 GMT by s_wx1085 (squid/3.5.20)
and view a module to make changes I get this message: "Error Accessing File. Network connection may have been lost." Does anyone know what this means or what I should do? Thanks for any help you can give. Guest, May 10, 2005 #1 Advertisements Guest Guest Your database is corrupt. I just went through this. Here is a website that will give you all the gory details and how to fix it. http://support.microsoft.com/default.aspx?scid=kb;[LN];304548 "KingsWay" wrote: > When I try and view a module to make changes I get this message: "Error > Accessing File. Network connection may have been lost." Does anyone know > what this means or what I should do? Thanks http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-2010-error-accessing-file-network/9ae829b3-f7c6-4f7c-b137-188363167aa4 for any help you can give. Guest, May 10, 2005 #2 Advertisements Jeff Conrad Guest "KingsWay" wrote in message: news:... > When I try and view a module to make changes I get this message: "Error > Accessing File. Network connection may have been lost." Does anyone know > what this means or what I should do? Thanks for any help you can give. Hi, Are you using Access 2000 without SP3 installed by chance? Is http://www.pcreview.co.uk/threads/ms-visual-basic-error-accessing-file.1645271/ so read on. I think you've been stung by a particularly nasty bug in Access 2000. Sure sign is that dreaded "Network Connection may have been lost.." message. Details about it can be found here: http://support.microsoft.com/?id=304548 The corruption in your database may not be recoverable. You might try importing everything into another database. I believe this bug is fixed with Service Pack 3, but it will not *fix* corruption already present. To avoid this bug you absolutely, positively, have to compile your database EVERY time you import something. Also, (from MVP Dirk Goldgar) one other thing you might try first is decompiling your database -- or rather, a copy of it. Instructions for how to do this may be found here: http://www.mvps.org/access/bugs/bugs0008.htm and here: http://www.granite.ab.ca/access/decompile.htm This was also posted by someone from Microsoft (my next employer): 326605 ACC2000: Issues Fixed in Access 2000 by Office 2000 Service Pack 3 http://support.microsoft.com/?id=326605 304548 ACC2000: Error Message: Error Accessing File. Network Connection May http://support.microsoft.com/?id=304548 After applying Office 2000 sp3 you are going to need to salvage your database modules (Standard, Forms/Reports) by saving them out to text files. Example: - Open Form/Report in design view and select menu option View > Code - Select the menu option Edit > Select All (to select vba code) - Select menu option Edit > Copy - Paste in Notepad file - Close VBA window to return
Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 05-20-2005, 04:18 AM http://www.access-programmers.co.uk/forums/showthread.php?t=87027 #1 atisz Newly Registered User Join Date: Apr 2005 Posts: 96 Thanks: 0 Thanked 0 Times in 0 Posts Error accessing file. Network connection may have been lost I think the damage to my database is not http://www.tek-tips.com/faqs.cfm?fid=2529 recoverable, but i'm still hoping. My computer crashed when I was working on my dtabase and after restart the db is not working anymore If I try to do something, anything (!!!) all I got is an error message: error accessing "Error accessing file. Network connection may have been lost." But the db is on my computer, I don't use it over the network. What can I do to make it working again? Thanx! Attila atisz View Public Profile Find More Posts by atisz 05-20-2005, 04:27 AM #2 ghudson Newly Registered User Join Date: Jun 2002 Location: USA Posts: 6,199 Thanks: 1 Thanked 74 Times in 43 Posts Before you do error accessing file anything, make a copy of it! Try importing all db objects into a NEW database. __________________ .................................................. ......Searching this forum or Microsoft.com or MSDN.com or Google is a great way to discover and learn the answers to your Access programming questions. Well if it seems to be real, it's illusion... I am using Access 2010 with Windows 7 The To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. function on this forum really does work. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. .................................................. ...... ghudson View Public Profile Find More Posts by ghudson 05-20-2005, 04:43 AM #3 atisz Newly Registered User Join Date: Apr 2005 Posts: 96 Thanks: 0 Thanked 0 Times in 0 Posts Huhhhhh! Oh, God! I was so scared! I tried to export it to a blank database, but it gaved me some errors, i think on the form wich were opened when the crash occured. After exporting, same errors. Now, following your advice, I exported again, but without selecting those forms wich were opened, and it's working!!!!!!!!!!!!!! Oh, I was so scared, I'm working on this db from 2-3 weeks, I was afraid that I lost everything. Thank you, thank you, Ghudson, now I
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules (VBA Coding) Forum at Tek-Tips Home > Forums > Programmers > DBMS Packages > Microsoft: Access Modules (VBA Coding) > FAQs Microsoft: Access Modules (VBA Coding) FAQ Forum Search FAQs Links MVPs Access - Select Dialogs Error Accessing File. Network Connection May Have Been Lost by remco5897 faq705-2529 Posted: 1Oct02 The import function in Access 2000 may cause a "Network Connection May have been Lost" error.This problem is described in the forum from many different angles.Below is a copy from the Microsoft knowledge base (Q304548) how you can solve this problem:ACC2000: Error Message: Error Accessing File. Network Connection May Have Been Lost.The information in this article applies to:Microsoft Access 2000Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). SYMPTOMSWhen you try to view the code for a module, try to compile a database, try to create an MDE file, or try to execute code in a Microsoft Access 2000