If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error in exporting forms
I tried to revise a form in the test environment, and when i exported the
form to production , we are getting this microsoft visual basic error "error accessing form, network connection may have been lost", then the visual basic codes popped up. I added some new fields in the table, so i have to change the data entry form nclude these new fields. Need help thanks. |
#2
|
|||
|
|||
Error in exporting forms
Are you using Access 2000 without SP3 installed by
chance? Is 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 he 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 he http://www.mvps.org/access/bugs/bugs0008.htm and he http://www.granite.ab.ca/access/decompile.htm This was also posted by someone from Microsoft: 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 to Form/Report - Within the properties Window of Form/Report change the property "Has Module" from "Yes" to "No" (this will delete the code behind the object) - Save your Form/Report ************* Repeat above steps for each Form/Report that has code ***************** - For your Standard module just open and copy to text files - Then import all your objects (within exception of your Modules) to a new database file - Copy the code from the above text files into new modules in your new database - For the Forms/Reports reverse the steps by opening their VBA modules and pasting the code from the text files ******************************* You can also try running decompile switch but the above methods are normally your only shot.. I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Good luck, -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conrad...essjunkie.html http://www.access.qbuilt.com/html/articles.html "Tarlac" wrote in message: ... I tried to revise a form in the test environment, and when i exported the form to production , we are getting this microsoft visual basic error "error accessing form, network connection may have been lost", then the visual basic codes popped up. I added some new fields in the table, so i have to change the data entry form nclude these new fields. |
#3
|
|||
|
|||
Error in exporting forms
Thanks everybody, i was able to export the form after installing the SP3. I
did not decompile , i just cut the VB code , exporte the form , pasted the VB code back. So far, the error is gone. THanks a lot "Tarlac" wrote: I tried to revise a form in the test environment, and when i exported the form to production , we are getting this microsoft visual basic error "error accessing form, network connection may have been lost", then the visual basic codes popped up. I added some new fields in the table, so i have to change the data entry form nclude these new fields. Need help thanks. |
#4
|
|||
|
|||
Error in exporting forms
"Tarlac" wrote in message:
... Thanks everybody, I was able to export the form after installing the SP3. I did not decompile , I just cut the VB code , export the form , pasted the VB code back. So far, the error is gone. Excellent good to hear. Make sure you keep good backups. -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conrad...essjunkie.html http://www.access.qbuilt.com/html/articles.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
printing only forms | Kagiso | General Discussion | 1 | December 14th, 2005 04:32 PM |
Cascading forms driving me crazy | David | Using Forms | 1 | December 1st, 2005 04:08 AM |
Problems when closing forms | Uros | General Discussion | 1 | October 21st, 2005 10:59 AM |
Menubar listing open forms? | Harmannus | Using Forms | 0 | December 23rd, 2004 12:33 AM |
datasheet forms open in form mode from the Switchboard | Paul James | Using Forms | 5 | July 13th, 2004 06:51 AM |