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

165 fields in a table not possible ?

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
"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

P: n/a
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.