473,385 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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
9 1502
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
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bob | last post by:
How can I copy query objects from one MS Access database to another using VB.net. Both databases are on the same computer. As I create a report using vb.net, I create and reference queries in a...
3
by: 21novembre | last post by:
Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup...
3
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...
2
by: Randy Harris | last post by:
I'm working with Access 2K and seem to be getting some behavior that contradicts the documentation. First, the help says: "Note The Activate event doesn't occur when a form receives focus back...
5
by: ChadDiesel | last post by:
My basic question is why does my print report button on my subform print a blank report when my cursor is on a blank entry line? Here is a more detailed explanation of my problem. I have a...
2
by: ThompsonJessical | last post by:
I am trying to use a button with the vba coding for SendObject Function to email a specific report based on the value of another field of the current record. The form is a continuous form and...
8
by: Randy | last post by:
Hi, is it possible to show the progress of a big file being copied e.g. in a "progressbar"? I tried to use file.copy - but this seems to make no sense :-( Thanks in advance, Randy
8
by: daD | last post by:
I'm trying to write a small database that tracks people coming and going from a small campground. I need to have the current guests in the "current" table" and then have the ability to check them...
2
easydoesit
by: easydoesit | last post by:
Hello all, I am looking for a way to be able to enter data into fields on a form, then be able to e-mail a report that shows only that record. This is what I have thus far: At the end of my...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.