dbTalk Databases Forums  

Bug when copying a form or report to another one?!

comp.databases.ms-access comp.databases.ms-access


Discuss Bug when copying a form or report to another one?! in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Raposa Velha
 
Posts: n/a

Default Bug when copying a form or report to another one?! - 01-02-2005 , 03:12 AM






Any of you ever catch this bug: I made a form and decided to copy it. Then I
modified the cloned form. Then I run it and access start saying "Error
accessing file. Network connection may have been lost." Then I tryed to
modify an event procedure and I realized that the correspondig code wasn't
copyed along with the form! Deleting the form didn't solve the problem and a
Compact and Repair Database did everything but reparing it! Actually I'm
really happy I was making backups really often because after this "Repair"
the whole DB become really shit, always with this message "Error accessing
file. Network connection may have been lost." Of course, again, I don't have
any network problem. I wounder what makes a programmer to put error messages
like this, trying to guess and missing the target!!! Oh well, this has been
a long night to finish a project and after having this bug 3 times my
patience gauge is really down. My solution has been going back to a previous
backup and draging the modified objects from the buggy DB to the OK one. And
crossing the fingers to not forget anything.
I'm using A2K and the database was split with database splitter. So if any
of you know how work around this, please let me know. And getting the newst
version whith this bug eventually solved and a few new ones as an extra is
out of question....
Thanks for any clue.



Reply With Quote
  #2  
Old   
'69 Camaro
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 04:52 AM






Hi, Raposa.

Quote:
And
crossing the fingers to not forget anything.
You, or someone who opened this database application, forgot to install MS
Office 2000 SP-3 after installing one of the MS Office XP or MS Office 2003
applications or Visio 2002 (any application that uses VBA 6.2) on the
computer. And you, or the other person, forgot to compile the code after
importing or copying code from another database application.

Please see this Knowledge Base article concerning a nasty bug:

http://support.microsoft.com/default.aspx?id=304548

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote

Quote:
Any of you ever catch this bug: I made a form and decided to copy it. Then
I
modified the cloned form. Then I run it and access start saying "Error
accessing file. Network connection may have been lost." Then I tryed to
modify an event procedure and I realized that the correspondig code wasn't
copyed along with the form! Deleting the form didn't solve the problem and
a
Compact and Repair Database did everything but reparing it! Actually I'm
really happy I was making backups really often because after this "Repair"
the whole DB become really shit, always with this message "Error accessing
file. Network connection may have been lost." Of course, again, I don't
have
any network problem. I wounder what makes a programmer to put error
messages
like this, trying to guess and missing the target!!! Oh well, this has
been
a long night to finish a project and after having this bug 3 times my
patience gauge is really down. My solution has been going back to a
previous
backup and draging the modified objects from the buggy DB to the OK one.
And
crossing the fingers to not forget anything.
I'm using A2K and the database was split with database splitter. So if any
of you know how work around this, please let me know. And getting the
newst
version whith this bug eventually solved and a few new ones as an extra is
out of question....
Thanks for any clue.





Reply With Quote
  #3  
Old   
Wayne
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 04:58 AM



Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.


Reply With Quote
  #4  
Old   
Raposa Velha
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 07:08 AM



Thhhaaaannnnnnkkk you both. It's true I hadn't the SP3. My quick search in
this NG didn't point me to the magic solution. Thanks again.
RV


"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

Quote:
Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.




Reply With Quote
  #5  
Old   
Raposa Velha
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 07:26 AM



Sorry to come to this one again. When running the SP3 patch of A2K, I got
this error maessage: "The expected version of the product was not found on
your system." Any idea? Of course it is installed!



"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

Quote:
Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.




Reply With Quote
  #6  
Old   
Jan Szymczuk
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 08:00 AM



Hi Raposa,

Yup, I had the same problems just before Christmas, same error message,
couldn't import or export forms etc. but since running the three Office 2000
service pack updates (in the correct order) problems are all gone (thanks
Wayne)

SP1
http://www.microsoft.com/downloads/d...displaylang=EN

SP2
http://www.microsoft.com/downloads/d...displaylang=EN

SP3
http://www.microsoft.com/downloads/d...displaylang=en

Jan



"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote

Quote:
Any of you ever catch this bug: I made a form and decided to copy it. Then
I modified the cloned form. Then I run it and access start saying "Error
accessing file. Network connection may have been lost." Then I tryed to
modify an event procedure and I realized that the correspondig code wasn't
copyed along with the form! Deleting the form didn't solve the problem and
a Compact and Repair Database did everything but reparing it! Actually I'm
really happy I was making backups really often because after this "Repair"
the whole DB become really shit, always with this message "Error accessing
file. Network connection may have been lost." Of course, again, I don't
have any network problem. I wounder what makes a programmer to put error
messages like this, trying to guess and missing the target!!! Oh well,
this has been a long night to finish a project and after having this bug 3
times my patience gauge is really down. My solution has been going back to
a previous backup and draging the modified objects from the buggy DB to
the OK one. And crossing the fingers to not forget anything.
I'm using A2K and the database was split with database splitter. So if any
of you know how work around this, please let me know. And getting the
newst version whith this bug eventually solved and a few new ones as an
extra is out of question....
Thanks for any clue.




Reply With Quote
  #7  
Old   
'69 Camaro
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 08:16 AM



Hi, Raposa.

Quote:
this error maessage: "The expected version of the product was not found on
your system."
Do you already have MS Office 2000 SR-1 or SR-1a installed? If not, it's
required before installing SP-3. However, you should also install SP-2
before SP-3, too, so that you have all of the service packs. SP-2 fixed a
lot of bugs, so you need it, too.

If you've already got the earlier service packs installed, then you may need
to insert your MS Office 2000 CD in the CD-ROM drive, or if it is an
upgrade, the CD from the earlier version of Office that qualifies for the
upgrade.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote

Quote:
Sorry to come to this one again. When running the SP3 patch of A2K, I got
this error maessage: "The expected version of the product was not found on
your system." Any idea? Of course it is installed!



"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote in message
news:1104663533.926156.323980 (AT) c13g2000cwb (DOT) googlegroups.com...
Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.






Reply With Quote
  #8  
Old   
Raposa Velha
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 07:45 PM



Thanks Jan. Got it :-)

"Jan Szymczuk" <szymczuk (AT) btinternet (DOT) com> wrote

Quote:
Hi Raposa,

Yup, I had the same problems just before Christmas, same error message,
couldn't import or export forms etc. but since running the three Office
2000 service pack updates (in the correct order) problems are all gone
(thanks Wayne)

SP1
http://www.microsoft.com/downloads/d...displaylang=EN

SP2
http://www.microsoft.com/downloads/d...displaylang=EN

SP3
http://www.microsoft.com/downloads/d...displaylang=en

Jan



"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote in message
news:41d7bb1d$0$1864$a729d347 (AT) news (DOT) telepac.pt...
Any of you ever catch this bug: I made a form and decided to copy it.
Then I modified the cloned form. Then I run it and access start saying
"Error accessing file. Network connection may have been lost." Then I
tryed to modify an event procedure and I realized that the correspondig
code wasn't copyed along with the form! Deleting the form didn't solve
the problem and a Compact and Repair Database did everything but reparing
it! Actually I'm really happy I was making backups really often because
after this "Repair" the whole DB become really shit, always with this
message "Error accessing file. Network connection may have been lost." Of
course, again, I don't have any network problem. I wounder what makes a
programmer to put error messages like this, trying to guess and missing
the target!!! Oh well, this has been a long night to finish a project and
after having this bug 3 times my patience gauge is really down. My
solution has been going back to a previous backup and draging the
modified objects from the buggy DB to the OK one. And crossing the
fingers to not forget anything.
I'm using A2K and the database was split with database splitter. So if
any of you know how work around this, please let me know. And getting the
newst version whith this bug eventually solved and a few new ones as an
extra is out of question....
Thanks for any clue.






Reply With Quote
  #9  
Old   
Raposa Velha
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-02-2005 , 07:46 PM



Yep, you've hit it

"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro (AT) Spameater (DOT) orgZERO_SPAM> wrote in
message news:mnTBd.23568$_62.14604 (AT) trnddc01 (DOT) ..
Quote:
Hi, Raposa.

this error maessage: "The expected version of the product was not found
on
your system."

Do you already have MS Office 2000 SR-1 or SR-1a installed? If not, it's
required before installing SP-3. However, you should also install SP-2
before SP-3, too, so that you have all of the service packs. SP-2 fixed a
lot of bugs, so you need it, too.

If you've already got the earlier service packs installed, then you may
need
to insert your MS Office 2000 CD in the CD-ROM drive, or if it is an
upgrade, the CD from the earlier version of Office that qualifies for the
upgrade.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote in message
news:41d7f675$0$3768$a729d347 (AT) news (DOT) telepac.pt...
Sorry to come to this one again. When running the SP3 patch of A2K, I got
this error maessage: "The expected version of the product was not found
on
your system." Any idea? Of course it is installed!



"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote in message
news:1104663533.926156.323980 (AT) c13g2000cwb (DOT) googlegroups.com...
Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.








Reply With Quote
  #10  
Old   
'69 Camaro
 
Posts: n/a

Default Re: Bug when copying a form or report to another one?! - 01-03-2005 , 04:55 PM



Glad it helped!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote

Quote:
Yep, you've hit it

"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro (AT) Spameater (DOT) orgZERO_SPAM> wrote
in
message news:mnTBd.23568$_62.14604 (AT) trnddc01 (DOT) ..
Hi, Raposa.

this error maessage: "The expected version of the product was not found
on
your system."

Do you already have MS Office 2000 SR-1 or SR-1a installed? If not,
it's
required before installing SP-3. However, you should also install SP-2
before SP-3, too, so that you have all of the service packs. SP-2 fixed
a
lot of bugs, so you need it, too.

If you've already got the earlier service packs installed, then you may
need
to insert your MS Office 2000 CD in the CD-ROM drive, or if it is an
upgrade, the CD from the earlier version of Office that qualifies for
the
upgrade.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Raposa Velha" <jmclopes (AT) hotmail (DOT) com> wrote in message
news:41d7f675$0$3768$a729d347 (AT) news (DOT) telepac.pt...
Sorry to come to this one again. When running the SP3 patch of A2K, I
got
this error maessage: "The expected version of the product was not found
on
your system." Any idea? Of course it is installed!



"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote in message
news:1104663533.926156.323980 (AT) c13g2000cwb (DOT) googlegroups.com...
Hi Raposa. I had the same problem when duplicating forms in Access
2000 and someone kindly pointed me to the Microsoft knowledge base
article that has been posted above. This problem and some other
strange ones that Access 2K seems to have, have caused me to steer
clear of it and either use Access 97 or a version later than 2K. I
haven't had the problems since adopting this approach.










Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.