Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Database Error 1

Status
Not open for further replies.

ErroR

Technical User
Apr 9, 2001
79
US
I have a piece of code (purely VBScript, no web stuff) that reads some registry keys, takes a piece of input from the user and then it pings a few servers and writes the "Min Max Avg" to a variable. Then, all the variables are written to an access database. However I will get an error sometimes:

The field is too small for the data, try pasting less data or increase the size of the field.

I'm kinda new to this so I'm not sure what I'm doing wrong, it doesnt always do it and it seems like it happened after I made the fields all bigger within the design view of the Access DB.
 
Sounds like an overflow error -- where you are trying to write a number like 100,000 to an integer field that can only hold 32k and some change --

On the fields that are accepting the data, make them 'float' or 'long' or something else so that you know the data will fit...

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top