Size

Sets or returns a long value that is the maximum size in bytes or characters of a Parameter object.

 

The Size property sets or returns a long value that allows you to define or determine the maximum size in bytes or characters of a value in a Parameter object. Note that this is the maximum, not the actual, size.

 

If you set a value for a Parameter object to be a variable-length data type, you must specify the Size before appending the object to the Parameters Collection, or an error will be generated. Similarly, if you change the data type of an already appended Parameter object to be a variable-length data type, you must specify the Size before executing the Command object, or an error will be generated.

 

You can use the Refresh method of the Recordset object to have the provider fill in parameter details. Under these circumstances, the provider will set the variable-length data types to be their maximum size and will allocate the necessary memory. Unfortunately, if memory is at a premium, an error may occur when you attempt an execution. Therefore, you may need to check the Size for provider-assigned variable-length data types.