crashes when copied...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that is supporting attendance record entry for our high
school. It is constantly being upgraded. I will develop the additions, of
course, on a copy and then copy them over to the "live" database once the
bugs are out.

The trouble is, sometimes, the changes work fine in the copy they were
developed under, but when I copy the new database objects to the real thing,
I get the following error message:

Error accessing file. Network connection may have been lost.

In this case, I have changed the target of one of our switchboard buttons to
point to a new form I developed. Simple enough, but...

Any ideas why this would happen?

Thanks.
 
Hello:

Might be this bug:
http://support.microsoft.com/?kbid=304548

HTH
Fred Boer

P.S. Decided to do a quick google groups search and I found this more
detailed post which I copy and reproduce here... Jeff is a wee bit
more...uh...comprehensive...
P.P.S. Veteran Newsgroupers who read this should take note of the comment
about his next employer. You may wish to call "Jeff's Psychic Hotline..."
(inside joke... <g>)


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 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 Dirk "Yoda" 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 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..

Good luck,
--
Jeff Conrad
Access Junkie
 
If I could be thankful and not in one?

Quite seriously, thank you for your response. I will set to work to ensure
all 400 workstations in our enterprise! <sigh>
--
BJM
ACE Assistant
Gary Allan High School


Fred Boer said:
Hello:

Might be this bug:
http://support.microsoft.com/?kbid=304548

HTH
Fred Boer

P.S. Decided to do a quick google groups search and I found this more
detailed post which I copy and reproduce here... Jeff is a wee bit
more...uh...comprehensive...
P.P.S. Veteran Newsgroupers who read this should take note of the comment
about his next employer. You may wish to call "Jeff's Psychic Hotline..."
(inside joke... <g>)


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 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 Dirk "Yoda" 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 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..

Good luck,
--
Jeff Conrad
Access Junkie
Click to expand...
 
You are welcome / My apologies... :)

Fred

B. Meincke said:
If I could be thankful and not in one?

Quite seriously, thank you for your response. I will set to work to ensure
all 400 workstations in our enterprise! <sigh>
Click to expand...
 
Back
Top