error msg: "Network Connection May have been lost"

[Gregorio]

Access 2000
Win XP Pro

I have a 23 mb application with many objects, and much code. Mysteriously
when opening got this error msg. It won't go away. I tried creating a blank
db and importing all objects to that shell, but the erorr comes with it.
Compact and Repair does nothing. I'm unsure where this came from out of the
blue.

Any ideas? - Thanks

 

[Guest]

This link will give you some info on your problem. It is a know evil ugly bug:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Here is a routine that may help:

1. Decompile
Start->Run msaccess.exe /decompile database name and path
2. open each standard module
Copy and paste the code into an external text file (I use notepad)
3. Do the same for each form and report that has code in it
After you copy the code, set the Has Module property to No
4. Create a new empty database
5. Import all the objects from the corrupt database except modules
6. Paste all your code from the text files back where they belong
7. Hope for the best

Good Luck and keep thinking - Backups are Good!

 

[Gregorio]

Indeed, evil. Ugly.

This link will give you some info on your problem. It is a know evil ugly
bug:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Here is a routine that may help:

1. Decompile
Start->Run msaccess.exe /decompile database name and path
2. open each standard module
Copy and paste the code into an external text file (I use notepad)
3. Do the same for each form and report that has code in it
After you copy the code, set the Has Module property to No
4. Create a new empty database
5. Import all the objects from the corrupt database except modules
6. Paste all your code from the text files back where they belong
7. Hope for the best

Good Luck and keep thinking - Backups are Good!

Access 2000
Win XP Pro

I have a 23 mb application with many objects, and much code. Mysteriously
when opening got this error msg. It won't go away. I tried creating a
blank
db and importing all objects to that shell, but the erorr comes with it.
Compact and Repair does nothing. I'm unsure where this came from out of
the
blue.

Any ideas? - Thanks

 

[Guest]

Let me know how it works out for you. The reason I am so knowledgable is
that I have the T Shirt.

Indeed, evil. Ugly.

This link will give you some info on your problem. It is a know evil ugly
bug:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Here is a routine that may help:

1. Decompile
Start->Run msaccess.exe /decompile database name and path
2. open each standard module
Copy and paste the code into an external text file (I use notepad)
3. Do the same for each form and report that has code in it
After you copy the code, set the Has Module property to No
4. Create a new empty database
5. Import all the objects from the corrupt database except modules
6. Paste all your code from the text files back where they belong
7. Hope for the best

Good Luck and keep thinking - Backups are Good!

Access 2000
Win XP Pro

I have a 23 mb application with many objects, and much code. Mysteriously
when opening got this error msg. It won't go away. I tried creating a
blank
db and importing all objects to that shell, but the erorr comes with it.
Compact and Repair does nothing. I'm unsure where this came from out of
the
blue.

Any ideas? - Thanks

 

[Gregorio]

Well, damn that t-shirt! What's not obvious is how to avoid having this
happen again. I also have Office 2003, if only my clients would move forward
to it! I just tried upgrading the db to 2002 version, didn't work. Tried
importing objects to new db in 2002 version and no go. At least the 2002
version is smart enough to know the old file is corrupt.

I have a backup a few days old, maybe revert and redo some work.

Thanks again, - Greg

Let me know how it works out for you. The reason I am so knowledgable is
that I have the T Shirt.

Indeed, evil. Ugly.

This link will give you some info on your problem. It is a know evil
ugly
bug:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Here is a routine that may help:

1. Decompile
Start->Run msaccess.exe /decompile database name and path
2. open each standard module
Copy and paste the code into an external text file (I use notepad)
3. Do the same for each form and report that has code in it
After you copy the code, set the Has Module property to No
4. Create a new empty database
5. Import all the objects from the corrupt database except modules
6. Paste all your code from the text files back where they belong
7. Hope for the best

Good Luck and keep thinking - Backups are Good!



:

Access 2000
Win XP Pro

I have a 23 mb application with many objects, and much code.
Mysteriously
when opening got this error msg. It won't go away. I tried creating a
blank
db and importing all objects to that shell, but the erorr comes with
it.
Compact and Repair does nothing. I'm unsure where this came from out
of
the
blue.

Any ideas? - Thanks

 

[Guest]

The only cause I have seen documented is, according to Microsoft, not having
Service Pack 3 installed for Windows 2000. I don't think that covers it all,
however, one of the people here had it happend and he is running XP Pro. I
do know that he was moving some changes I made into production and rathter
than Import the modified objects, he had both versions open and did a
copy/paste. He got the message a few minutes later.

Well, damn that t-shirt! What's not obvious is how to avoid having this
happen again. I also have Office 2003, if only my clients would move forward
to it! I just tried upgrading the db to 2002 version, didn't work. Tried
importing objects to new db in 2002 version and no go. At least the 2002
version is smart enough to know the old file is corrupt.

I have a backup a few days old, maybe revert and redo some work.

Thanks again, - Greg

Let me know how it works out for you. The reason I am so knowledgable is
that I have the T Shirt.

Indeed, evil. Ugly.

This link will give you some info on your problem. It is a know evil
ugly
bug:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Here is a routine that may help:

1. Decompile
Start->Run msaccess.exe /decompile database name and path
2. open each standard module
Copy and paste the code into an external text file (I use notepad)
3. Do the same for each form and report that has code in it
After you copy the code, set the Has Module property to No
4. Create a new empty database
5. Import all the objects from the corrupt database except modules
6. Paste all your code from the text files back where they belong
7. Hope for the best

Good Luck and keep thinking - Backups are Good!



:

Access 2000
Win XP Pro

I have a 23 mb application with many objects, and much code.
Mysteriously
when opening got this error msg. It won't go away. I tried creating a
blank
db and importing all objects to that shell, but the erorr comes with
it.
Compact and Repair does nothing. I'm unsure where this came from out
of
the
blue.

Any ideas? - Thanks