<div>
As I found out, I am using 120columns in my table. Technically I should be able to use more...but Access tells me NO MORE!<br />
The design is poor, there is no question about that. I came the the game, when most of it was done already. I am going to clean up, too. But by boss'es requests are more important right now.<br />

</div>


<div>
Just to let you know:<br />
Access2003 kept rows in the table &quot;reserved&quot; and were not accesseble any more. I converted the DB into 2007, complete and got few error messages. I deleted the tables and the quesries and all is good now. Even though, Access asked you to use the 2007 system, it did not convert the database!<br />

</div>


<div>
&gt;...but Access tells me NO MORE!<br />
Can you provide a screen shot of this error? &nbsp;Access tables support 255 columns. 
</div>


<div>
<div class="content wysiwyg-content">
Hi there,<br />
I have a database with a table. I reached the limit of 255 columns. I attached a new table with a one-to-one relationship. If I use this in a form, I get the message: exceeded 255 data fields.<br />
I feed 4 different forms from one query, should I seperate the data in query, to make it work.<br />
any other ideas?<br />
Thanks Josh
</div>
</div>


Hi there,
I have a database with a table. I reached the limit of 255 columns. I attached a new table with a one-to-one relationship. If I use this in a form, I get the message: exceeded 255 data fields.
I feed 4 different forms from one query, should I seperate the data in query, to make it work.
any other ideas?
Thanks Josh

As I found out, I am using 120columns in my table. Technically I should be able to use more...but Access tells me NO MORE!
The design is poor, there is no question about that. I came the the game, when most of it was done already. I am going to clean up, too. But by boss&#39;es requests are more important right now.


Just to let you know:
Access2003 kept rows in the table &quot;reserved&quot; and were not accesseble any more. I converted the DB into 2007, complete and got few error messages. I deleted the tables and the quesries and all is good now. Even though, Access asked you to use the 2007 system, it did not convert the database!


&gt;...but Access tells me NO MORE!
Can you provide a screen shot of this error?  Access tables support 255 columns. 

Expanding table size

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.