473,216 Members | 1,462 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 software developers and data experts.

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 1125
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tim Chmielewski | last post by:
For an auto-generated form I have the following order of fields: savevalues userid productcode PrintColour1_1 Colour1_1 Quantity_1 " " " " " " " ...
0
by: Megan | last post by:
Hi Everybody- I know that this is a really, really long post, but I wanted to try to give you as much background as possible. So here's a quick overview of the issues I'm asking for help with:...
8
by: Bill | last post by:
Hello out there; This may be a challenge but I'm certain it's possible but I can't seem to figure out how. I have a table that has several date fields, e.g., Date1, Date2, Date3, Date4 ......
1
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...
3
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...
6
by: allyn44 | last post by:
HI--what I am trying to do is 2 things: 1. Open a form in either data entry mode or edit mode depending on what task the user is performing 2. Cancel events tied to fields on the form if I am in...
0
by: Ennio-Sr | last post by:
Hi all! After a very long struggle I finally succeded in transferring my old *.dbf file and the relating *.dbt (alias memo fields) to a pg table. For the time being I put the memo field in a...
9
by: Jimbo | last post by:
Hello, I have a user request to build a form in an Access database where the user can check off specific fields to pull in a query. For example, let's say I have 10 fields in a table. The user...
7
by: riceking | last post by:
Is it possible to do the following and if so, how? In one table, I have a list of email addresses I know are bad and no longer work. Another table has a list of companies with contact people,...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.