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.
12 1570
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...
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.
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?
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?
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?
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?
Is it possible to rationalise the data structure ... 180 fields is a pretty fat table .. or have I missed the point.?
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.?
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!
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!
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.
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Patrizio |
last post by:
Hi All,
I've the following table with a PK defined on an IDENTITY column
(INSERT_SEQ):
CREATE TABLE MYDATA (
MID NUMERIC(19,0) NOT NULL,
MYVALUE FLOAT NOT NULL,
TIMEKEY ...
|
by: Andy Skypeck |
last post by:
I am looking for some validation against a dubious coding practice
that prevails where I work. C types defined in types.h (Linux) or
stdint.h (Windows, C99?) are used as if they belong to the C++...
|
by: tom |
last post by:
I am new to SQL administration.
>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.
...
|
by: Stuart Turner |
last post by:
Hi Everyone,
I'm working hard trying to get Python 'accepted' in the organisation I work
for. I'm making some good in-roads. One chap sent me the text below on
his views of Python. I wondered...
|
by: Thelma Lubkin |
last post by:
My form/subform combination that allows user to display 'ColorSet'
records, move to other records via a selector, to add,delete, and
edit them, and to manage the related 'Color' records from the...
|
by: karthi |
last post by:
hi,
I need user defined function that converts string to float in c.
since the library function atof and strtod occupies large space in
my processor memory I can't use it in my code.
regards,...
|
by: john |
last post by:
I have a form with 1 table. I would like to create a field in my form that
shows the number of records (of the whole table) that have one particular
value. Is that possible? I fiddled with a...
|
by: bcap |
last post by:
Hello,
I really would apprciate help! =)
What I want to do is be able to change the status of mulitple records
using a drop down and a checkbox.
I have a drop down called "ChangeStatus"...
|
by: rolan |
last post by:
I am trying to figure out how to store and access an array, which is created inside a function, and needs to be accessed outside the function.
My user defined class has set and get functions for 2...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |