Maximum Table Size?

[Bonnie A]

Hi everyone! Happy post-Thanksgiving withdrawals as left-overs diminish!

I'm using A02 on XP.

I have a DB for internal contract audits and it's just one big table with 2
forms and a few reports.

I seem to have hit a wall on adding fields to my table. I have
approximately 162 fields and it won't let me add any more. I get the error:
Property value is too large.

There are no fields that can be logically moved to another table. It's just
a questionaire with comment fields and a few dates. I guess I can have
Table1 and Table2 and link them but I only need a few more fields.

Vaguely related question: I saw a post that dealt with DB file size at 2GB.
Can a table alone get too big? I've got a few log and tracking tables that
have over 200,000 records. But, they also don't get 'used' alot.

Thanks in advance for your time and advice!

 

[Jeff Boyce]

Bonnie

If you have a table with over ... 30 fields ... your DB may be ... a
spreadsheet! If it is "just a questionnaire", then why bother using Access?
Could you do what you want to with a spreadsheet instead?

If you want to get the best use of Access' relationally-oriented
features/functions, you can't feed it 'sheet data. Take a look at
"normalization" if you want to be using Access to its capabilities.

Good luck!


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jerry Whittle]

The maximum number of records for a table is a little over 133 million
records. That's 133 million useless records with just one field and one
character in each record.

As for your problem, 162 fields is too wide. If you normalized your data
properly, you'll probably have less than 10 fields in a table that is linked
to at least one other table with probably about 10 fields.

For an idea of a properly normalized Survey database, download Duane
Hookom's At Your Survey at the following link:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane