Table: Number of columns limit

[hycho]

Hi All,

I have to submit a file to a government agency that requires more than 200 columns. Is there a number of column limit an Access table can have?

Thanks.

 

[John Big Booty]

I believe the limit is 255, however I suspect that if you are running into this limit, you may have a problem with your table structure. Read up on normalisation and perhaps work through a tutorial.