By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Hi, Raposa.
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
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" <cq*******@volcanomail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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.

Nov 13 '05 #4

P: n/a
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" <cq*******@volcanomail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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.

Nov 13 '05 #5

P: n/a
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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.

Nov 13 '05 #6

P: n/a
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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" <cq*******@volcanomail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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.


Nov 13 '05 #7

P: n/a
Yep, you've hit it :)

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:mnTBd.23568$_62.14604@trnddc01...
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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" <cq*******@volcanomail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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.
>



Nov 13 '05 #8

P: n/a
Thanks Jan. Got it :-)

"Jan Szymczuk" <sz******@btinternet.com> wrote in message
news:cr**********@titan.btinternet.com...
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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.


Nov 13 '05 #9

P: n/a
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.telepac.pt...
Yep, you've hit it :)

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in message news:mnTBd.23568$_62.14604@trnddc01...
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" <jm******@hotmail.com> wrote in message
news:41**********************@news.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" <cq*******@volcanomail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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.
>



Nov 13 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.