Too many fields defined

G

gbeato

hello, I´m a new user of microsoft access. I´ve working on
a database creating the tables and one table has 112
entries and when i try to save it the program told me that
there are too many fields defined. I reduce to the half
the amounto of fields but still told me that are too many
fields defined.

if somebody knows about this problem, i will apreciate if
could tell me, because the help of access don´t have an
answer for this problem.
 
K

Kevin3NF

Compact and repair will get you past this problem (ever y deelted field is
still counting against you).

Properly designing your database, as I suspect you may not have done, will
get you past all of the future problems you are going to encounter. :)

In a properly designed database, very few situations need that many fields
in one table.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

message hello, I´m a new user of microsoft access. I´ve working on
a database creating the tables and one table has 112
entries and when i try to save it the program told me that
there are too many fields defined. I reduce to the half
the amounto of fields but still told me that are too many
fields defined.

if somebody knows about this problem, i will apreciate if
could tell me, because the help of access don´t have an
answer for this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

35 fields 5
too many fields defined 3
Too Many Fields Defined 3
too many fields defined 2
too many fields defined 1
Too Many Fields Defined Error 1
Too Many Fields Defined 1
Too many fields defined 2

Top