Re: too many fields
Philo wrote:
>> You would have the same problem with MSSQL, as its ADO that has the
>> field limit, not the database.
>
> True but when working with lots of data go with products made for the
> real world. My thought is sooner or later one has to be there, might
> as well do it now and reap the rewards and therefore avoid the pain.
Completely agree with you there, just wanted him to be aware that if he
changed to MSSQL it wouldn't fix the problem, but it would be a step in
the right direction if he did that and changed the database design.
Steve
|