Access Database

T

Tim Ferguson

Why can't Access Database hold more than 255 Characters
Click to expand...
It can:

a) a Text field is limited to 255 chars, but a Memo field is unlimited up
to the size of the mdb file

b) a Record can hold up to 2048 bytes, not including Memo fields which only
contribute 8 bytes each (I think)

c) a Table can hold as much information as will fit inside the mdb file

d) an mdb file can hold up to 2GB

HTH


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Difference in size of actual access database and its backup 0
Table field length limit alternative 8
Expanded box 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Text Field Size - Access 2007 2
Memo field only allowing 255 Characters 8
Copy and move Access 13 database on laptop to pc with Access 13 0

Top