Limit to field size in SQL statement

wperzel

New member
Local time
Today, 01:18
Joined
Mar 12, 2002
Messages
8
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
 

Users who are viewing this thread

Back
Top Bottom