Search results

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...

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...

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...