Thread: several questions RE tables
View Single Post
  #2  
Old March 29th, 2010, 09:22 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
  
Posts: 1,017
Default several questions RE tables
You can only have 255 fields max in a table.

Steve



"Ret" wrote in message
...
I'm using Access 2007 and I want to transfer data from one table (an
import)
to another table. Every time I try an append query I lose most of the
records. I've tried to format the records the same and now just about any
changes I make in either table I get the messege "Too many fields
defined".
Help?!
--
Ret