HOW TO EXPAND THE NUMBER OF FIELDS IN AN ACCESS TABLE

[Guest]

USING ACCESS 2000
I am developing a form for data that requires aprox. 400 fields. The table
only allows for 255 fields.
Is there a method to expand the number of fields in a table.

 

[PC Datasheet]

No. The design of your table is unequivocally wrong! You need to normalize
the design and break the humongous table down into multiple smaller tables.

 

[Rick B]

If you are using more than 20 or 30 fields in a table, then your design is
most likely flawed.

Access is a relational database. Proper design would cause one to create
different tables for different types of data and link them (or set
relations).

For example, a database might have a table with basic employee data (name,
address, phone, etc.) a second table might contain salary history
information (this would be tied to the first table by the employee number or
some similar key). A third table might have training history for each
empoloyee and would be tied to the main table by the employee number.


You would have to give us specific details if you would like more
assistance, but you need to 'normalize' your design.

Rick B