By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Too many records defined! 8-digits accepted in SS#

P: 78
I'd appreciate help! I'm working with an Access 2000 SP# database, buitl it all myself, but with 41 fields left to create, when I try add them as columns in the table or in the design view, when I try to change field text size for some of the fields already created, I get "too many fields defined." Also-- when I did the routine for a social Security template, it only accepts all but the last digit. Does this call for an exorcism? Thaks so much.
Jan 8 '07 #1
Share this Question
Share on Google+
12 Replies


ADezii
Expert 5K+
P: 8,638
I'd appreciate help! I'm working with an Access 2000 SP# database, buitl it all myself, but with 41 fields left to create, when I try add them as columns in the table or in the design view, when I try to change field text size for some of the fields already created, I get "too many fields defined." Also-- when I did the routine for a social Security template, it only accepts all but the last digit. Does this call for an exorcism? Thaks so much.
The Maximum number of Fields that can be defined in an Access Table is 255.
I'm assuming that you have an Input Mask defined for your Social Security Field, if so the Mask(s) should be as follows:

'Stores SSANs without Symbols: 000\-00\-0000;;_

'Stores SSANs with Symbols: 000\-00\-0000;0;_

(The 2nd Parameter (0) dictates whether or not literals are stored in the underlying Table as well as the number itself.) Hope this helps...
Jan 8 '07 #2

P: 78
Thanks for replying-- there are only 214 fields filled in. I'll get back to you on the SS# problem when I have a chance to work on your solution.
Jan 9 '07 #3

P: 78
adEZII-
your recommended SS# fix didn't work.

And instead of counting the fields remaining, I counted the fields I've already used-- 180!!! any idea what's going on?
Jan 9 '07 #4

P: 78
The Maximum number of Fields that can be defined in an Access Table is 255.
I'm assuming that you have an Input Mask defined for your Social Security Field, if so the Mask(s) should be as follows:

'Stores SSANs without Symbols: 000\-00\-0000;;_

'Stores SSANs with Symbols: 000\-00\-0000;0;_

(The 2nd Parameter (0) dictates whether or not literals are stored in the underlying Table as well as the number itself.) Hope this helps...
Re: Too many records defined! 8-digits accepted in SS#
--------------------------------------------------------------------------------
The social security fix you gave doesn't work. I also counted the fields I've used-- there are only 180!!! What else should I try?
Jan 10 '07 #5

P: 36
What is the size of the file now? Could you run compact and repair.



Re: Too many records defined! 8-digits accepted in SS#
--------------------------------------------------------------------------------
The social security fix you gave doesn't work. I also counted the fields I've used-- there are only 180!!! What else should I try?
Jan 10 '07 #6

P: 78
What is the size of the file now? Could you run compact and repair.
how do i determine the size of the file, and how would I compact and repair?
Jan 10 '07 #7

alpnz
100+
P: 113
Is it possible to rationalise the data structure ... 180 fields is a pretty fat table .. or have I missed the point.?
Jan 10 '07 #8

P: 36
First 180 fields in one table is not really normal for me.

To check the file size, first close your mdb then right-click and select properties or just see it in windows explorer.

To compaq and repair: Open your mdb then goto Tools -> Database Utilities -> Compaq and Repair Database.

George


Is it possible to rationalise the data structure ... 180 fields is a pretty fat table .. or have I missed the point.?
Jan 11 '07 #9

P: 78
First 180 fields in one table is not really normal for me.

To check the file size, first close your mdb then right-click and select properties or just see it in windows explorer.

To compaq and repair: Open your mdb then goto Tools -> Database Utilities -> Compaq and Repair Database.

George
Thanks. It's now compacted and repaired, and I can add additional fields and modify all. I still have the SS# problem, though. One would think that if Access allows 255 fields, 180 would not be abnormal. Being self-taught has its limitations; I don't know if I would have the time for building this another way. However, if you could tell me how to get it to delete a record with an out-of-range date, it would help!
Jan 11 '07 #10

P: 78
First 180 fields in one table is not really normal for me.

To check the file size, first close your mdb then right-click and select properties or just see it in windows explorer.

To compaq and repair: Open your mdb then goto Tools -> Database Utilities -> Compaq and Repair Database.

George
thanks for your help; I'm all set for the present!
Jan 16 '07 #11

P: 78
Is it possible to rationalise the data structure ... 180 fields is a pretty fat table .. or have I missed the point.?
thanks for your input. I'm doing the best I can with what I know! all set for the present.
Jan 16 '07 #12

P: 78
The Maximum number of Fields that can be defined in an Access Table is 255.
I'm assuming that you have an Input Mask defined for your Social Security Field, if so the Mask(s) should be as follows:

'Stores SSANs without Symbols: 000\-00\-0000;;_

'Stores SSANs with Symbols: 000\-00\-0000;0;_

(The 2nd Parameter (0) dictates whether or not literals are stored in the underlying Table as well as the number itself.) Hope this helps...
thanks for your help; I'm all set for the present
Jan 16 '07 #13

Post your reply

Sign in to post your reply or Sign up for a free account.