Unclear error message (VB .NET and MDB)

[rahavtom]

Hello !

 

I have two datasets. I'm updating them with values from the user (by form), and then I'm trying to save the datasets into my mdb database, using "update" command:

 

daGlobalOBUSTitles.Update(dsOBUSTitles, "OBUSTitles")

daGlobalOBUSDetails.Update(dsOBUSDetails, "OBUSDetails")

 

The first line goes perfect and the data from the dataset is being stored to the database, but the second line (different dataset) I get the following error message:

 

"The field is too small to accept the amount of data to attempted to add. Try inserting or pasting less data"

 

I don't understand this error, because when I tried to run this line with almost empty dataset, I got the same error.

 

My question is if someone knows this error or can tell me if there are any limits on the size or amount of fileds that can be stored by this way.

 

Last thing, the first line (first dataset) contains a table with 14 fields and the other one contains table with 26 fields.

 

By the way, when I display the dataset on a datagrid I get it perfect...

 

Many Thanks!

Tom.

[pendragon]

I found an article by microsoft with this error and it says the following

 

If you set a column size smaller than the data currently in the field, you receive the following message, and the data type change will not occur:

 

In an Access database (.mdb):

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

 

Hope this helps