Error Accessing File - Need Nurse maid

[Andy]

I have several problems and need to explain them slowly, that is why I ask
for a nurse maid. I am using Access 2000 but ultimatley must convert the
Database to Access 97 for usage in VB6.

In my test data base in AC2000 every thing works OK. When I export to the
other DB which is also at this time in AC2000 it supposedly exports. When I
go to use the code section I get a message "Error Accessing file. Network
connection may have been lost." I don't know what is going on and can not
make corrections.

How do I clear this error?

Andy Pagorek

 

[Allen Browne]

Andy this sounds like this very nasty old corruption:
Error Accessing File. Network Connection May Have Been Lost
at:
http://support.microsoft.com/?id=304548

Microsoft fixed this problem long ago, so you really need to apply the
service packs for your Office 2000 if you are getting this error. You can
get them from:
http://support.microsoft.com/sp/
Be sure to get the one for JET as well (listed there under Developer.)

The service packs won't fix the corrupted database, so you will need to
revert to a backup. But they will prevent it recurring.

I can't be your nurse maid, but hopefully that heads you in the right
direction.

BTW, I don't think you will have to convert to A97 format just to use VB6.
Depends what library you reference.

 

[Andy]

Allen,

Thank you for accessing my problem and guiding me in the right direction. It
took awhile to gather and read the information, but it opened a new area to
research for me.
The application is working fine. I do have 2 follow up questions.

1. "BTW, I don't think you will have to convert to A97 format just to use
VB6."

"Depends what library you reference."???? What do you mean by the library
reference.?

2. Also when I install vb6 updates what library do I install in?
Windows\System or the library that vb6 is loaded in.?

Guess I will have to change my sign in name. Several Andy's out there.

Andy

 

[Allen Browne]

It's been ages since I've used VB6, but my recollection is that from the
code window you can choose References? And you have Microsoft DAO 3.5x
referenced? If you replace it with DAO 3.6, you should be able to read
Access 2000, 2002, or 2003 files.

You can add references to windows\system or system32, but be careful of
overwriting existing ones. For custom ActiveX controls it might be safer to
put them in your program's own folder. They should work if you register them
there e.g.:
regsvr32 "C:\MyFolder\MyLib.dll"