Recent content by davidfox

So there is no advantage to trying to keep the sizes of Text fields small, as long as I compact the database occasionally. It sounds as though I could set all the Text fields to their allowable maximum length, as the size of the database will still be determined primarily from the amount of...

Will keeping your field size shorter result in a smaller MDB file? Or does Access only use as much space as there is real data in its fields. Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the...

I've got a few questions on storing dates in an MDB using SQL UPDATE... (1) I would prefer to have empty date fields really be empty (rather than some unusal date like January 1, 0001 or whatever). If a textbox.text equals "", what would I set the corresponding field in the database to? Some...

Awesome. Thanks a million.

I am helping a company reorganize its employee data to reflect recent changes in the company's organization. It involves a lot of data manipulation that, for the most part, can't be done programatically. I can save a little time using SQL update queries like this: update personnel set...

Thanks for the reply. I was hoping you were going to say that.

I would imagine that reading through someone else's normalization problems is as exciting as watching paint dry. But I have seen some brilliant answers presented here so I'll give it a shot. I'll try to be brief and concise. I'm hoping someone can read through this and tell me if I'm on the...