470,810 Members | 880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

165 fields in a table not possible ?

Hello all,
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error saying
that I cannot have more than 255 fields in a tables, while the actual number
of fields is 165 .... how is this possible ?
Any help very much appreciated ....
Ronny
Nov 12 '05 #1
5 1072
Ronny,
Congratulations on trying to build such a massive table.
Whilst you may have a good reason to want to build such a wide table perhaps
you may want to re-think your table design.
What on earth are you trying to build ?
regs

Nig

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40*********************@news.skynet.be...
Hello all,
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error saying that I cannot have more than 255 fields in a tables, while the actual number of fields is 165 .... how is this possible ?
Any help very much appreciated ....
Ronny

Nov 12 '05 #2
Well, this is all about sending different texts (143) via email depending on
various situations. The date/time fields serve to keep record of the dates
the different mails have been sent.

Greetings,
Ronny
"Tombsey" <no************@nospam-tiscali.co.uk> schreef in bericht
news:40**********@mk-nntp-2.news.uk.tiscali.com...
Ronny,
Congratulations on trying to build such a massive table.
Whilst you may have a good reason to want to build such a wide table perhaps you may want to re-think your table design.
What on earth are you trying to build ?
regs

Nig

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40*********************@news.skynet.be...
Hello all,
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error

saying
that I cannot have more than 255 fields in a tables, while the actual

number
of fields is 165 .... how is this possible ?
Any help very much appreciated ....
Ronny


Nov 12 '05 #3
Sounds like you need to build down not across.
textid,datetime

So only two fields are required, but would produce 143 records for each
textid

dont think spreadsheet, think database
Probably no help, but thought I would give it a shot

regs
Nig

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40***********************@news.skynet.be...
Well, this is all about sending different texts (143) via email depending on various situations. The date/time fields serve to keep record of the dates
the different mails have been sent.

Greetings,
Ronny
"Tombsey" <no************@nospam-tiscali.co.uk> schreef in bericht
news:40**********@mk-nntp-2.news.uk.tiscali.com...
Ronny,
Congratulations on trying to build such a massive table.
Whilst you may have a good reason to want to build such a wide table

perhaps
you may want to re-think your table design.
What on earth are you trying to build ?
regs

Nig

"Ronny Sigo" <ro********@skyynet.be> wrote in message
news:40*********************@news.skynet.be...
Hello all,
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error

saying
that I cannot have more than 255 fields in a tables, while the actual

number
of fields is 165 .... how is this possible ?
Any help very much appreciated ....
Ronny



Nov 12 '05 #4
"Ronny Sigo" <ro********@skyynet.be> wrote:
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error saying
that I cannot have more than 255 fields in a tables, while the actual number
of fields is 165 .... how is this possible ?


While I would agree that you should consider bulding your table down and not across
the answer is to compact your database. That will reset this number. What has
happened is you've created, deleted, renamed and otherwise mucked with 255 fields.
Compacting will reset this number back to the 165 so you can have another go at it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #5
Hi Tony,
I will surely do this the "relational way". But anyhow thanks for solving
the fields problem.
Greetings,
Ronny

"Tony Toews" <tt****@telusplanet.net> schreef in bericht
news:5m********************************@4ax.com...
"Ronny Sigo" <ro********@skyynet.be> wrote:
I tried to define a table with 165 fields (most of them are date/time
fields) Yet when saving the table definition Access gives me an error sayingthat I cannot have more than 255 fields in a tables, while the actual numberof fields is 165 .... how is this possible ?
While I would agree that you should consider bulding your table down and

not across the answer is to compact your database. That will reset this number. What has happened is you've created, deleted, renamed and otherwise mucked with 255 fields. Compacting will reset this number back to the 165 so you can have another go at it.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ennio-Sr | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.