Re: Access's datatypes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bonj (Bonj_at_discussions.microsoft.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 07:48:09 -0700

mmmm... it *nearly* is. I basically could do with a list of all the
sub-datatypes within 'Number' - and how many bytes they take up. For
instance, how many bytes does a "Number (Single)" (SQL_REAL) take up? It's
just to show somebody who's convinced that we can save space in our
(*apparently* space-critical) Access system by using a smallint divided by
1000 instead of a float for percentages and what not, and he just will not
let it drop until I prove that we are absolutely optimizing the size of the
DB. (the Access database is only 77MB at the moment...not exactly bursting at
the seems, but apparently it will eventually expand such that we've got so
many databases they won't fit on a CD, which is how they are going to be
distributed.)
If I can show that a float takes up the same size as a 16-bit int, then I
won't have to bother changing it, which would be a right P.I.T.A as it will
probably have absolutely zero impact on anything if I do - but I suspect it
takes up 32 bits.... (sigh)... but still. I have to look into it.

Relevant Pages

  • Re: Accesss datatypes
    ... Access system by using a smallint divided by ... (the Access database is only 77MB at the moment...not exactly bursting at ... If I can show that a float takes up the same size as a 16-bit int, ... probably have absolutely zero impact on anything if I do - but I suspect it ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Accesss datatypes
    ... > If I can show that a float takes up the same size as a 16-bit int, ... > probably have absolutely zero impact on anything if I do - but I suspect ... Lookup FieldSize Property in MSAccess Help. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Accesss datatypes
    ... > If I can show that a float takes up the same size as a 16-bit int, ... > probably have absolutely zero impact on anything if I do - but I suspect ... Lookup FieldSize Property in MSAccess Help. ...
    (microsoft.public.vb.general.discussion)
  • Re: invalid class typecast
    ... That's right to use Float is a soln. ... >> MS Access database supports the INT64 fields. ...
    (borland.public.delphi.database.ado)
  • RE: PyTime Object and Application Crashing
    ... >> When I run a query against an access database and the default ... Access the date value as a float, ... > return datetime.datetime.combine(aDate, aTime) ...
    (comp.lang.python)