2. ASPRunnerPro General questions
  3. Maximum Number of Fields?
This topic is locked

Maximum Number of Fields?

 		4/29/2008 1:35:16 PM
ASPRunnerPro General questions
A
 ashumak author

I am getting an error on my edit page
[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.
I guess with 20 players, 3 coaches a manager's info as well as team name and division I have maxed out access.

\Q. If I move to an SQL server dBase, will I have the same problem?
Any easy way to do this and not have to rebuild everything?
Or is there a way to break down the one table into sections for edits only?
Alan
Sergey Kornilov admin 4/29/2008

Alan,
MS Access don't allow to use more than 128 in update queries.

You can switch to SQL Server that don't have this limitation however this is a bad design.
I would suggest to normalize your data splitting into into several tables.
A
 		ashumak author 4/30/2008

I seem to be running in circles. I had the information split into tables, but was advised that too many tables is no good. Now one table is no good.
What about MySql dbase?
I guess the problem I have is trying to figure how to combine a table each for players, coaches and managers into listings that show like this:


How do I set up the fields so that the 20 players, 3 coaches and one manager are listed as shown???