record too large...

[Antoine Vuillermet]

Guys, thanks for your cooperation !

Another question, I wrote a function which allows me to translate my
fields name, from english to chinese. Basically it works like this :

creation of a buffer field, copy of field1 (=active field in my
database) data to the buffer, copy of field2 (translated data) data in
field1, and copy of buffer data to field2, erase buffer field.

It seems to work just fine, but after 10-15 times of translating back
and forth, I've got a error message, "record is too large", and at that
point only, I seem to have lost many of my original datas...

Thanks !
Antoine.

 

[John Nurick]

Hi Antoine,

I'm not sure I understand your description of what you're doing, but
here are some things to watch out for:

1) if you're making extensive and repeated alterations to the structure
of your tables, you need to compact and repair the database frequently.

2) if the routine operation of your database (as opposed to design and
setup) requires altering the structure of tables, your design is almost
certainly wrong. If it requires the regular creation of new tables, the
design is probably wrong - unless they're temporary tables, in which
case it may be best to put them in a separate, temporary, mdb file.

3) The Jet database engine that Access normally uses has a limit of
about 2000 characters in any record, excluding memo, hyperlink and OLE
fields. This overrides the sizes of individual fields: for example, if
you have 20 text fields, each with a size of 255 characters, you can't
fill them all before you hit the 2000 character limit.