Invalid Argument error on long text fields

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

Hi,

I am using forms in MS Access 2000, SP3 to connect to a
SQL Server 2000 database. Many of the data entry forms
have a command button that, when clicked, runs a SQL
INSERT statement to add the values to the database. For
the most part, this works great. However, if any of the
values for any of the fields in the INSERT statement have
any more than 125 or 130 characters in it, we get
an "Invalid Argument" error.

Has anyone else encountered this issue? What do I need to
do do fix this?

Any help would be greatly appreciated.
 
This may or may not relate to your problem, but I have
read here and there and everywhere that Access has a bug
in it.

if you are using a "backend" and a "frontend" and you
link the tables from the backend to the frontend and the
backend table path (c:\documents and settings\..ect) is
longer than 128 Chars then chances are you will get an
error message that pops up "acces has encountered a
problem and needs to close" when you try to use the
tables.

I do believe that the 128 char path bug is right, I
encountered it, and I moved my front and backend to the
root of the drive in a single folder, and the problem
went away.

Rowland
 
Bearing in mind that an Access table can have not more than 2k characters in
a record, it may be that Access queries cannot handle more than 2k
characters per record either. So even if the SQL Server table can accept
more, the problem may be that Access cannot generate such a long record.

If that is the problem, a workaround might be to run several INSERT queries
in tandem, each on a different set of fields.
--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top