yes/no and byte field type

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

Sometimes, I need to have yes/no field to store binary information.
I just wonder does MS Access use a bit or a byte to store the data.
If MS Access use a byte to store a binary information then I can just
use a byte, since it can have 256 possibilities data to store.

I know today memory costs less then before, but if the table has
millions records still make difference.


Thanks in advance for the informaiton,
 
Memory and storage are two different things and will remain so for a while
longer.
Since Access uses variable length field sizes for text, even millions of
records will usually take far les storage than you think.
I'm not sure when you should consider switching to SQL back end but that
will remove limitations and you can just buy an additional drive.
 
m:
Sometimes, I need to have yes/no field to store binary
information. I just wonder does MS Access use a bit or a byte to
store the data. If MS Access use a byte to store a binary
information then I can just use a byte, since it can have 256
possibilities data to store.

I know today memory costs less then before, but if the table has
millions records still make difference.
Click to expand...

Worrying about this is called "premature optimization".
 
Here's another angle on something to consider:
    Why I stopped using Yes/No fields
at:
   http://allenbrowne.com/NoYesNo.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -
Click to expand...

Thanks millions for the information,
 
Back
Top