pass-through queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use some pass-through queries i one database to download data from a
sqlserver - this in turn gets inserted into a table in another access
database.

I am geeting the error that the field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less data.

this does not happen every month - and I have not changed anything with the
database? Is this strictly an Access problem, or is the extraneous data in
a one of the fields in sql server? when I look at the link table info I can
get so far in the table - but onceI reached a certain record I get the above
error and everything blanks out and I get #name in all the fields!

Help! The person responsible for the sql server does not believe it is a
problem on his end so I need to figure out what I can do. I have already
made all text fields 255, dates are yyyymmdd, numbers are long integer.

any help appreciated.

using access'97 - I know it is old - but it is stable. hopefully moving
towards sql server in the not too distant future!
 
Is there anything special about that specific row at which point the error
occurs? SQL Server can hold more than 255 characters in text fields, or
perhaps the numbers are outside of the range of a Long Integer
(-2,147,483,648 to 2,147,483,647)
 
I can not even look at the data in the record!

Douglas J. Steele said:
Is there anything special about that specific row at which point the error
occurs? SQL Server can hold more than 255 characters in text fields, or
perhaps the numbers are outside of the range of a Long Integer
(-2,147,483,648 to 2,147,483,647)
Click to expand...
 
Back
Top