On Mon, 29 Mar 2010 16:37:01 -0700, Ret wrote:

Thank you. I am no longer having problems with the "Too many fields
defined". Don't know what changed that.

You probably have "Compact on Close" checked in the database's properties, so
it compacted automatically for you.

However, I have been unable to
transfer a yes/no field properly. Any suggestions?

Since I have no idea what you're transfering from, transfering to, or how
you're doing the transfer, not really. All I can say is that an Access Yes/No
field is stored as -1 for Yes, 0 for No, other values (and NULL values)
prohibited.
--

John W. Vinson [MVP]