Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Ms-Access data error
Name: mm05111975 Date: October 12, 2004 at 23:27:03 Pacific OS: Windows 98 CPU/Ram: 128 Meg RAM
Comment:
Hello, I have written some Ms-Access queries (in version Ms-Access 2000), when I execute some of them and bring up the records in the database, I sometimes receive an error message as follows: "Microsoft Access - Scaling of decimal value resulted in data truncation". Any ideas as to what it causing this or how to fix ?
Name: rayok Date: October 13, 2004 at 10:24:38 Pacific
Reply:
what this means is that your number / data had a whole load of numbers after the decimal point, the length (width) of the field was not enough to display them all so some of the end was got lost
Increase the field size, or, limit the size of the number via the table, in design view, FIELD SIZE
Summary: I have an Excel S/sht which is linked in MS Access. The fields can be either text, numeric or both. I get #Num! errors in the Access version of the Excel S/sht, the data type is wrong but I can't fix ...
Summary: Hi, I am working with a MS access data base. I have used Database splitter to separate tables and other objects so that it can allow concurrent connections to the database. In the sense it can be shar...
Summary: Running Office 2000 and trying to use MS Access to look at an existing database. I get msg "An error occurred and this feature is no longer functioning properly. Do you want to repair it?" When I say ...
0 
