I have to create about one hundred tables , each of them with at least 230 fields.The field names are "very incremental" (i mean a000_01, a000_02, a000_03 etc), so i prefer to generate field names using Excel facilities. After that, i use some code like <Set Fd = Td.CreateField("a000_01", dbBoolean, 1)> to generate the tables.
The major problem is that I don't know how to set the Format of these fields. The generated tables have Yes/No at DataType but Format is left blank, which causes me a lot of errors. But that's not all: if i want to manualy set Format to Yes/No, i receive a warning like 'Too many fields defined' so i have to "compact and repair database" after modifying each 20-30 fields. Any help would be apreciated! Thanks!

The design you are trying to use is really not correct. It violates the "rules" of normalization.

You should put this data into a child table the only has the fields, Primary Key, Rec Type, a000.

Then you can have as many records as need.

check out:

http://msdn.microsoft.com/library/de...cesstables.asp

HTH...




Boyd
Access Based Accounting/Business Solutions developer.