RE: MS Access and AS/400 files

[bmegenity@xxxxxxxxxx]

Gary,
 Access does not give a length to numeric fields except as defined in the   
field types:
If the DataType property is set to Number, the FieldSize property   
settings and their values are related in the following way.

Setting  Description    Decimal precision Storage size

Byte Stores numbers from 0 to 255 (no fractions).  None  1 byte

Integer Stores numbers from -32,768 to 32,767 (no fractions). None  2   
bytes

Long Integer (Default) Stores numbers from -2,147,483,648 to   
2,147,483,647 (no fractions).       None  4 bytes

Single Stores numbers from -3.402823E38 to -1.401298E-45 for negative   
values and from
1.401298E-45 to 3.402823E38 for positive values.  7  4 bytes

Double Stores numbers from -1.79769313486231E308 to   
 -4.94065645841247E-324 for negative values and from 1.79769313486231E308   
to 4.94065645841247E-324 for positive values.        15  8 bytes  

Bill Megenity  bmegenity@ruskin.com  (day)  twinstar@sound.net (pm)

 ----------
From:  Gary_Lehman@mail.mchcp.org
Sent:  Tuesday, August 04, 1998 2:19 PM
To:  MIDRANGE-L@midrange.com
Subject:  MS Access and AS/400 files

 --------------------------------------------------------------------------  
 --
Hi, any MS Access and AS/400 experts?.  In Access when you do a link   
table
is there a way to tell Access how the fields in the table are set up?   
 What
I mean is it can see the fields and know what type they are, but it   
doesn't
seem to know how to configure the length.  For instance, we have a Social
Security Number field and it knows it's a number, but it does not know   
that
the field has been set up to be length of 9.  It uses integer or long
integer and does not specify a length.  It sets up a field to be longer   
than
9 and the data fields on the AS/400 file are incorrect.

 Any help would be appreciate.
Thanks,

Gary Lehman
Programmer Analyst
Missouri Consolidated Health Care Plan

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to   
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:   
david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---