Dennis wrote:

According to specs, No of chars in record (excluding Memo and OLE) with
Unicode Compression property set to Yes is 4,000. Thanks for the info.

That's correct.

I know that I just posted on aspect of the perfermance question, but
unfortunately I don't know enough about Access to know the performance
questions to ask.

Performance isn't the problem.

You asked how do I know how "big" each record is? I added up the field
lenght of each field. I don't know if Access have variable length fields or
fix length records. Until I can figure out differently, I'm assuming that
Access has fixed length record.

Access test fields are all variable character length. (Actually you
can make them fixed length but you have to set a property via code or
something like that.) One problem that may happen though is that a
person may be typing away in the 30th field and hit the 4 kb limit and
be rather puzzled as to what is going on.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/