Field Limit in Access 2007

[boblarson]

I am working on a database to monitor childhood obesity and for each referral we need to store about 600 items of information, i.e diet, activity, eating hablits etc this has to be recorded 4 times over a 12 month period. So you do get exceptions to long and thin.

Although, actually if done with the right frame of mind, you can do this one long and thin too. I know of what I speak because I actually worked on an Access program for a Patient Registry system for tracking chronic care details, demographics, treatments, medications, risk factors, immunizations, consults & education, vitals, labs, referrals, other measures, and other diagnostic tests.

So, it CAN be done - but you have to look at it in the right way to do so.