Tue 3 Jul 2007, 17:24Delegate Edmund said...
Edmund has attended:
Access Introduction course
Access Intermediate course
Fields
How do i add more fields. i have a database that has currently 200 fields. I keep getting error message that maximum fields reached. How do I get more fileds, is approximately 200 the maximum fields allowed. thanks
Wed 4 Jul 2007, 12:42
Edited on Wed 4 Jul 2007, 12:42Trainer David said...
RE: fields
Hi Edmund
200 fields is a lot.
If you just have 1 table with 200 fields I would suggest that you break that table down into lots of smaller tables. The purpose of Ms access is to allow you to have lots of tables that hold similar information, these tables are linked together using primary and foreign keys. You can then run reports and queries to extract data.
Hope this helps
David
