Can you tell me how many fields Access will allow in a table. As I stated
in a previous post, I need to track multiple measurements from machines 10
per day. In some cases this will give me 120 measurements or more. I could
put one check on one record but I was hoping to find a way to put all 10
checks (120 measurements) into one record. So far I really haven't gotten a
reply I understand other than do one record per check.
I've been trying to do:
Check#1 measurement, measurement, measurement, etc
Check#2 measurement, measurement, measurement, etc
all the way to
Check#10 measurement, measurement, measurement, etc.
Now this method will work but I have to create 120 fields to do it. When
I've tried Access tells me it's too many fields.
I was wondering how many fields you can actually have?
Don.............
6  2885 
Don:
For Access 2003, the maximum number of fields is 255. If you go to Access
help and search "Access Specifications" you will find a help topic detailing
the various limits in Access.
--
David Lloyd
MCSD .NET http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:HqZ0f.2599$ar6.284@trndny01...
Can you tell me how many fields Access will allow in a table. As I stated
in a previous post, I need to track multiple measurements from machines 10
per day. In some cases this will give me 120 measurements or more. I could
put one check on one record but I was hoping to find a way to put all 10
checks (120 measurements) into one record. So far I really haven't gotten a
reply I understand other than do one record per check.
I've been trying to do:
Check#1 measurement, measurement, measurement, etc
Check#2 measurement, measurement, measurement, etc
all the way to
Check#10 measurement, measurement, measurement, etc.
Now this method will work but I have to create 120 fields to do it. When
I've tried Access tells me it's too many fields.
I was wondering how many fields you can actually have?
Don.............
Thanks David that's really handy.
I see where in Access 2000 (which I'm using) it says I can have 255 fields
in a table. However I have, as near as I can count 126 fields in one of my
tables. When I try to add another I get a message "too many fields
defined". I thought this meant I had too many. Now I'm not sure what it
means, do you have any idea?
Thanks for the tip,
Don............
"David Lloyd" <Da***@NoSpamPlease.com> wrote in message
news:qf***************@bignews7.bellsouth.net... Don:
For Access 2003, the maximum number of fields is 255. If you go to Access
help and search "Access Specifications" you will find a help topic
detailing the various limits in Access.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:HqZ0f.2599$ar6.284@trndny01...
Can you tell me how many fields Access will allow in a table. As I stated
in a previous post, I need to track multiple measurements from machines 10
per day. In some cases this will give me 120 measurements or more. I
could put one check on one record but I was hoping to find a way to put all 10
checks (120 measurements) into one record. So far I really haven't gotten
a reply I understand other than do one record per check.
I've been trying to do:
Check#1 measurement, measurement, measurement, etc
Check#2 measurement, measurement, measurement, etc
all the way to
Check#10 measurement, measurement, measurement, etc.
Now this method will work but I have to create 120 fields to do it. When
I've tried Access tells me it's too many fields.
I was wondering how many fields you can actually have?
Don.............
"Don Sealer" <vz******@verizon.net> wrote in message
news:Hw%0f.2437$7P5.2206@trndny07... Thanks David that's really handy.
I see where in Access 2000 (which I'm using) it says I can have 255 fields
in a table. However I have, as near as I can count 126 fields in one of
my tables. When I try to add another I get a message "too many fields
defined". I thought this meant I had too many. Now I'm not sure what it
means, do you have any idea?
Thanks for the tip,
Don............
Don, I'm not sure about this, but it seems to me that I remember reading
somewhere (perhaps this ng) that if you delete fields those still count
toward your 255 limit. If that is indeed the case, you could try a make
table query from the table you've got now to a new table and see if it will
let you add more fields.
Don:
The following KB article deals with the issue Randy mentioned. http://support.microsoft.com/default...b;en-us;291556
--
David Lloyd
MCSD .NET http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:Hw%0f.2437$7P5.2206@trndny07...
Thanks David that's really handy.
I see where in Access 2000 (which I'm using) it says I can have 255 fields
in a table. However I have, as near as I can count 126 fields in one of my
tables. When I try to add another I get a message "too many fields
defined". I thought this meant I had too many. Now I'm not sure what it
means, do you have any idea?
Thanks for the tip,
Don............
"David Lloyd" <Da***@NoSpamPlease.com> wrote in message
news:qf***************@bignews7.bellsouth.net... Don:
For Access 2003, the maximum number of fields is 255. If you go to Access
help and search "Access Specifications" you will find a help topic
detailing the various limits in Access.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:HqZ0f.2599$ar6.284@trndny01...
Can you tell me how many fields Access will allow in a table. As I stated
in a previous post, I need to track multiple measurements from machines 10
per day. In some cases this will give me 120 measurements or more. I
could put one check on one record but I was hoping to find a way to put all 10
checks (120 measurements) into one record. So far I really haven't gotten
a reply I understand other than do one record per check.
I've been trying to do:
Check#1 measurement, measurement, measurement, etc
Check#2 measurement, measurement, measurement, etc
all the way to
Check#10 measurement, measurement, measurement, etc.
Now this method will work but I have to create 120 fields to do it. When
I've tried Access tells me it's too many fields.
I was wondering how many fields you can actually have?
Don.............
Thanks Randy for the advice. I did as you suggested and I was able to add
more fields.
Thanks again,
Don.............
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:0P*************@newssvr17.news.prodigy.com...
"Don Sealer" <vz******@verizon.net> wrote in message
news:Hw%0f.2437$7P5.2206@trndny07... Thanks David that's really handy.
I see where in Access 2000 (which I'm using) it says I can have 255
fields in a table. However I have, as near as I can count 126 fields in one of my tables. When I try to add another I get a message "too many fields
defined". I thought this meant I had too many. Now I'm not sure what
it means, do you have any idea?
Thanks for the tip,
Don............
Don, I'm not sure about this, but it seems to me that I remember reading
somewhere (perhaps this ng) that if you delete fields those still count
toward your 255 limit. If that is indeed the case, you could try a make
table query from the table you've got now to a new table and see if it
will let you add more fields.
Thanks David. I did get more fields added but the article helps me to
understand how to fix this problem should it arrive in the future.
Hopefully I'll never want that many fields again.
Don............
"David Lloyd" <Da***@NoSpamPlease.com> wrote in message
news:h1***************@bignews5.bellsouth.net... Don:
The following KB article deals with the issue Randy mentioned.
http://support.microsoft.com/default...b;en-us;291556
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:Hw%0f.2437$7P5.2206@trndny07...
Thanks David that's really handy.
I see where in Access 2000 (which I'm using) it says I can have 255 fields
in a table. However I have, as near as I can count 126 fields in one of
my tables. When I try to add another I get a message "too many fields
defined". I thought this meant I had too many. Now I'm not sure what it
means, do you have any idea?
Thanks for the tip,
Don............
"David Lloyd" <Da***@NoSpamPlease.com> wrote in message
news:qf***************@bignews7.bellsouth.net... Don:
For Access 2003, the maximum number of fields is 255. If you go to
Access help and search "Access Specifications" you will find a help topic detailing the various limits in Access.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"Don Sealer" <vz******@verizon.net> wrote in message
news:HqZ0f.2599$ar6.284@trndny01...
Can you tell me how many fields Access will allow in a table. As I
stated in a previous post, I need to track multiple measurements from machines
10 per day. In some cases this will give me 120 measurements or more. I
could put one check on one record but I was hoping to find a way to put all 10
checks (120 measurements) into one record. So far I really haven't
gotten a reply I understand other than do one record per check.
I've been trying to do:
Check#1 measurement, measurement, measurement, etc
Check#2 measurement, measurement, measurement, etc
all the way to
Check#10 measurement, measurement, measurement, etc.
Now this method will work but I have to create 120 fields to do it.
When I've tried Access tells me it's too many fields.
I was wondering how many fields you can actually have?
Don.............
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bill mahoney |
last post by:
I have access 2k and I have 2 tables. One is a 7X6 table representing
a month with zeroes padding the fields where no day exist. For example
February 2003
0 0 0 0 0 0 1
2 3 4 5 6 7 ...
|
by: Melissa |
last post by:
I have a frontend file named CustomerApp and backend file named CustomerData.
CustomerApp is at C:\Customer Database and CustomerData is at S:\Customer
Database. Could someone help me with the code...
|
by: sparks |
last post by:
I was copying fields from one table to another.
IF the var name starts with milk I change it to egg and create it in
the destination table.
It works fine but I want to copy the description as...
|
by: Megan |
last post by:
Hi everybody-
I'm helping a friend with a music database. She has an old one and is
creating a new one. She wants to compare records and fields in the old
database with records and fields in the...
|
by: ND |
last post by:
I need to create a separate field from 4 fields, "street address", "city",
"State" and "zip code". For example,
Street address - 100 Forest Street
City - Seattle
State - WA
Zip - 05555
...
|
by: svdh |
last post by:
I have posed a question last saturday and have advanced alot in the
meantime. But I am still not there
Problem is that I try to merging various fields from various tables in
one document in Word...
|
by: google |
last post by:
I have a database with four table. In one of the tables, I use about
five lookup fields to get populate their dropdown list. I have read
that lookup fields are really bad and may cause problems...
|
by: Kosio |
last post by:
Is there any way to setup a make-table query so that it names the
fields of the new table based on values in a different table.
For example, I have the following fields: Noun, Adjective, Modi 1...
|
by: steph |
last post by:
I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that...
|
by: bonneylake |
last post by:
Hey Everyone,
Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place.
...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
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: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
| |
