!Yikes!!Office 2000 Access db doesn't port to 2000 Access in Office XP

[mikeydamike]

I designed a database in Access 2000 as part of the Office 2000 suite. Then, when I attempted to deliver the db to the client who is running Office XP Small Business (with the Access 2000 part) I ran into all kinds of trouble. On my machine (Win 98, Office 2000) everything works great including the Visual Basic Module. However, on the client's machine whenever they attempt to use the form which uses VB routines to calculate prices, etc. they get the error "Microsoft Visual Basic Error - Error Accessign File. Network connection may have been lost. The Expression OnClick you entered as the event property setting produced the following error: Error Accessingn Gile, Network Connection may have been lost. * The Expression may not result in the name of the macro, the name of a user-defined function or [Event Procedure]. * There may have been an error evaluating the function, event or macro"

What's weird is that this message is irregular. At first, the db worked fine. Then, this message started popping up. Then, when I was trying to debug the situation on the client's machine, their visual basic module would not let me change code. It would display code, but as soon as I started typing new code, it would display the above "error accessing file" message. I uninstalled Office XP Small Business and reinstalled - no luck. Access 2000 is on a separate CD in the Office XP Small Business suite. I installed everything properly but still get that message. The built-in help suggests an add-in to list file structure, but the add-ins on the Office XP Small Business disks are blank....

Please help and thanks so much! -mike

 

[mikeydamike]

P.S. The client is a stand-alone box, no network at all.

 

[JDavey]

I just ran into this same issue, except that I developed a report on a machine running Win2000/Access2000 and emailed my client a report. Upon importing the report to their machine (running Win98 and Access2000), they got the error you mentioned.

There is an article on MSDN which addresses this problem:

http://support.microsoft.com/support/kb/articles/Q304/5/48.ASP?

]Error - Network Connection May Have Been Lost

Hope this helps!

 

[votegop]

I also had this problem. No doubt, it sucks! Someone told me you could change the .dll to the old version mentioned in the MS article, and then recompile. It didn't work for me. I lost 2 weeks worth of work! (stupid me for not backing-up more frequently, I guess you only do that once)

Good luck.