Specifikationer på .ADP fil

Hi Hugo
Because the data is in an SQL server then this is wh<t you need to look at in relation to the limitations on tables.

http://www.mssqlcity.com/Articles/Compare/SQLvsAccess.htm

Thanks - that gave me 99,9% of the information i needed (I always want to know more :-)  )
I may have to start on a project where I will need >500 fields in one table!
I may been beating on my head to get an idea as how to reduce this but I only got more headache

Make an answer to get the points

500 fields seems a lot. Are you sure you cant normalize into other related tables?
Hopefully you dont hav eto show all 500 fields on one form.

Tak

I have some labtest that can consist of many different messurments and each of these has 4 productspecification-values that I need to check them against to see if they are within the specifications or they are to be rejected for use.
I simply can't figure out another way to do this. Speed also has something to say here. A lookup in 4 tables could be a posibility, but as all fields has to be shown on one form (on different tabs) in order to maitain the specifications I have given up on that.

I haven't counted the exact number of fields yet but I believe it to be around 80-90 (times 4)

Wasn't there a time when you were active on Messenger (or Skype)