Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Empty fields in table 1

Status
Not open for further replies.
macca007

macca007

Programmer
May 1, 2004
86
GB
Hi all i would like to know if some fields in the table are empty i.e not used. Does it occupy space (does the database increase in size)

cheers
 
Sort by date Sort by votes
Apart from an overhead of 1 byte per column in each record, then No. Empty text fields occupy no space, for example.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
305
andre.meyer
A
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
953
renigar
renigar
ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top