Jet error - field is too small
Posted on 2006-04-26
I'm using vbs code to create a database table in Access 2003.
I've defined the fields to be 'about' the right character limit, with a shave more where it may be anticipated.
However, once the code runs, and I try to execute my Insert statement, I get this error:
Microsoft JET Database Engine: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
Must be a JET issue, as I took the statement exactly and successfully pasted it as an INSERT query in Access.
After traversing through all fields that were written to the table, each one is lengthed the same as I set it up in my code! :(
(a) how do I find 'which' field (or fields) are too long for Jet
(b) or how do I get around this? Is there a dynamic method to creating field lengths?