Has anyone encountered a problem with size of memo fields when using VBA SQL to add records to a new table.
The error message I am encountering is;
Run Time error 3188
Could not update; currently locked by another session on this machine.
As soon as I reduce the size of the field, it runs until it hits the next large field.
I thought I read someone's note about a 2084 byte limit.
Is this true and is there a way around it?
Warren
The error message I am encountering is;
Run Time error 3188
Could not update; currently locked by another session on this machine.
As soon as I reduce the size of the field, it runs until it hits the next large field.
I thought I read someone's note about a 2084 byte limit.
Is this true and is there a way around it?
Warren