September 9, 2008 at 10:11 am
Using MS Access 97 SQL Server tables were linked. Some records show as #Error and the message says "The filed is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."
The field size in SQL Server is nvarchar(255). That is linked as Text of which size 255.
How to avoid the error and get those records?
THanks,
September 9, 2008 at 11:49 am
I think I solved that once by changing something on the form/report in Access, but it's been too many years for me to remember what it was. Is there a size setting on the form?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 9, 2008 at 11:55 am
I am not using any forms/reports. I just created a query in Access,and it gives an error described above. Basically my question would be the capability of Access to link in terms of data size.
Thanks
September 9, 2008 at 12:47 pm
That, I can't answer.
My application was an Access project on an SQL database. No Access database, no linked tables, etc. Never had to deal with those.
Hopefully, someone else will have more data on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply