K
kostadin
is it possible to make a table with more than 255 fields?
it is very important for my project.
it is very important for my project.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
kostadin said:is it possible to make a table with more than 255 fields?
it is very important for my project.
No.
The desire to make a table with that many fields is "almost certainly" caused by
an improper design. What you are trying to represent in a single table most
likely should be distributed among multiple related tables.
What is the data that you are trying to work with?
S
Steve Schapel
Kostadin,
No, it is not possible.
It is very likely that the data structure you have in mind is not
"normalised". If you would post back with some more details of the
fields you need, with examples, someone will be able to offer some
good advice as to a valid table design.
- Steve Schapel, Microsoft Access MVP
No, it is not possible.
It is very likely that the data structure you have in mind is not
"normalised". If you would post back with some more details of the
fields you need, with examples, someone will be able to offer some
good advice as to a valid table design.
- Steve Schapel, Microsoft Access MVP
G
Guest
i know how i can solve the problem but it will be very
difficult. i must remake all my source code. does SQL
support "long" table (with more fields)?
difficult. i must remake all my source code. does SQL
support "long" table (with more fields)?
G
Guest
I know that probably there are many solutions for my
project. The main problem is that i didn't check maximum
fields of the table in access. Now i have tons of invalid
vba code.
project. The main problem is that i didn't check maximum
fields of the table in access. Now i have tons of invalid
vba code.
is "almost certainly" caused by-----Original Message-----
No.
The desire to make a table with that many fields
V
Van T. Dinh
That why you should design the Table Structure first and make sure it
satisfies the Relational Database Design Principles before actually
implement it and move on to later stages of the database implemetations
(Queries / Forms /Reports). Even if you can use a temp. work-around, e.g.
breaking into 2 Tables with 1-to1 relationship, there will be other problems
later.
Thus, the only sensible solution is to go back and start with a properly
designed Table Structure.
satisfies the Relational Database Design Principles before actually
implement it and move on to later stages of the database implemetations
(Queries / Forms /Reports). Even if you can use a temp. work-around, e.g.
breaking into 2 Tables with 1-to1 relationship, there will be other problems
later.
Thus, the only sensible solution is to go back and start with a properly
designed Table Structure.
S
Steve Schapel
Konstantin,
properly in the first place?
a lot of headaches.
- Steve Schapel, Microsoft Access MVP
This is curious. If you know how to do it, why didn't you do iti know how i can solve the problem
properly in the first place?
It may be difficult in the short term, but long-term it will save youbut it will be very
difficult. i must remake all my source code.
a lot of headaches.
No.does SQL
support "long" table (with more fields)?
- Steve Schapel, Microsoft Access MVP
D
Douglas J. Steele
Steve Schapel said:Konstantin,
No.
Actually, Steve, it does. According to BOL, a table in SQL Server can have
up to 1,024 fields (and the row size limit is 8,060 bytes)
Of course, just because it's possible doesn't mean it's a good idea!
S
Steve Schapel
Sure, Doug. I wasn't relating to SQL Server. I interpreted
Konstantin's question to mean whether in Access he could make a query
with more fields.
- Steve Schapel, Microsoft Access MVP
Konstantin's question to mean whether in Access he could make a query
with more fields.
- Steve Schapel, Microsoft Access MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.