If you check the tables used in the query, go to the last record and see if
all records from vantage were linked successfully. You might need to create
a macro or code to refresh links at start up before running your queries.
Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, November 07, 2001 9:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [Off-Topic] MS Access error question - updating 4.0 to
5.0
I am working on updating my linked access reports for 5.0. Everything seems
to be going smoothly, until I go to run the queries, and I get the Access
error "Scaling of decimal value resulted in data truncation" and then the
query will not run.
This is the same exact query I had with the 4.0 database and it worked fine.
When I go to Access help, it says "Error 3759: This error occurs when the
data being updated or inserted into a DECIMAL data type does not match the
defined scale and precision of the column."
Nothing has changed in the query since 4.0, I am very confused as to what is
causing this and how to fix it. If anybody has seen this error before and
can provide any help, I would be very grateful!
Thanks,
Sarah
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
all records from vantage were linked successfully. You might need to create
a macro or code to refresh links at start up before running your queries.
Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, November 07, 2001 9:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [Off-Topic] MS Access error question - updating 4.0 to
5.0
I am working on updating my linked access reports for 5.0. Everything seems
to be going smoothly, until I go to run the queries, and I get the Access
error "Scaling of decimal value resulted in data truncation" and then the
query will not run.
This is the same exact query I had with the 4.0 database and it worked fine.
When I go to Access help, it says "Error 3759: This error occurs when the
data being updated or inserted into a DECIMAL data type does not match the
defined scale and precision of the column."
Nothing has changed in the query since 4.0, I am very confused as to what is
causing this and how to fix it. If anybody has seen this error before and
can provide any help, I would be very grateful!
Thanks,
Sarah
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/