It says too many fields defined...I was trying to shrink my field size on an already saved db and it came up with the same problem. I am using access 2013 and have 100 fields. I am having this problem with all of the forms, queries, and tables I am making...Am I suppose to save them in a different format or something?
Reply from Alex Hedley:
That seems like a lot of Fields for 1 Table, it might need normalising.
One option would be to backup the database and then run a compact and repair. If that doesn't work try importing the table into another blank database and trying again. If that doesn't work you might need to split the table.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.