Table Limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am creating a table and when I get to about the 155th field it says I have
reached the limit and when I look up in the Help it says it can hold 255
fields in a table. Does anyone have an idea on why that would be happening?

Thanks so much.

Lucy.
 
Hi,
155 fields in a table??? Is your data proparly normalized. This is an unusal
big amount of fields for a table. Normally you should split the data as much
as possibe into relating tables.
Maybe you can clarify your table structure/set up.
Try a compact and repair though (tools--database utilities...) if you add
and delete fields the counter does not get reset until you compact, so you
could run out before actually reaching the max.
HTH
Good luck
 
Do a Compact & Repair and then try again.

When you delete a field, that field still exists internally and counts
against the 255 limit until you compact (the deleted field will also
continue to take up disk space until you compact).

Similarly, when you change the Data Type of a field, Access doesn't really
change the field. What it really does is create a new field of the specified
type, copies "old" data into it and then deletes the "old" field. But the
deleted field will continue to count against the 255 field limit until you
compact.

HTH,
 
Lucy,

If you have entered fields in the table, and then deleted them again, I
think the deleted ones still count towards the total, until you compact
the database.

In practice, it is very unusual for a table to require that many fields
anyway, so your question almost certainly indicates an error in your
design. If you would like some feedback on this aspect, please post
back with some examples of these 155 fields you are putting into the table.
 
Hi Steve,

Thanks so much for the reply.
Steve, I am trying to create a fixed-length file in access, where I am
pulling some fields from an external database, others are hard-coded, need
calculations or are just left blank. The file layout has 155 fields. I am
only putting it in a table, so I have the correct layout and field widths. Do
you know of or can you suggest a better way to do this?

Thanks,
 
Hi Steve,

Thanks so much for the reply.
Steve, I am trying to create a fixed-length file in access, where I am
pulling some fields from an external database, others are hard-coded, need
calculations or are just left blank. The file layout has 155 fields. I am
only putting it in a table, so I have the correct layout and field widths. Do
you know of or can you suggest a better way to do this?
Click to expand...

PMFJI but... if you're assuming that you must have the table laid out
in the same way as the export, your assumption is incorrect. The two
have almost nothing to do with one another. Tables are for data
storage, not for presentation or for export!

You can export from a Query just as easily as from a Table; and using
the File Export wizard, you can specify the layout and field widths
independently of those in the table or the query.


John W. Vinson[MVP]
 
Hi John,

You are a star! Thank you so much.
John, if this is going to be a daily export, do you know if there
is a way to make the export keep the field settings that you define in the
export wizard, without having to define them each time?

Thanks again for your help.
 
Lucy,

On the final screen of the wizard, if you click the Advanced button, you
can save the setup as a Specification. This specification can then be
used within a macro or VBA procedure using the TransferText method to
automate your export.
 
Thank you so much Steve! You are all so incredibly helpful!

Steve, if my query has prompts, and I am trying to use the export wizard, I
know that you have to set up parameters, and you need to type in the prompts
used in the query, as well as the data types. I have 2 prompts for dates, and
I have entered it as follows: "Semi-Monthly Date", with a data type of
"Date/Time" and another prompt, "Bi-Weekly Date" with a data type of
"Date/Time". Is this format correct, do I need to put parentheses around
these prompts, when defining it in the parameters? Because, when I try and
run the export, it says, "Too few parameters. Expected 2", and when I look it
up in the help, it says I need to define the parameters.

If you could help with any of this, it would be greatly appreciated.

Thanks again Steve :)
 
Back
Top