February 22, 2010 at 12:14 pm
Hi, looking for some advice, hope someone can help me out. I have an Access 2002 database that I'm using as a front end of an application. The back end is a SQL Server 2005 database. I use Access mainly to collect the data entry and use SQL Server to store it. My issue is that I have several fields where I need to allow the user to enter pretty much as much text as they want, up to 4000 characters. This 4000 character limit is defined in the SQL Server table. I thought that as long as I had a text box set up on Access to allow the user to enter their data, I could thru VBA take the data and using an INSERT statement, put the entire contents in the field. It's not working, it's only allowing me to put in about 238 characters. (it's acting like a memo field). Can anyone give me some pointers? Do I have to have the table defined a certain way? I don't think there are any triggers or anything that are being used, (haven't found out yet from the DBA) that might be causing the issue but am I not going to be able to paste this much text from Access to SQL Server?
Any help is greatly apppreciated....
thanks!
February 22, 2010 at 12:19 pm
Did you try to design your form row based.
I'm not an access specialist, but I've done some access 2003 things and didn't have issues with that.
I used a msaccess 2003 ADP project with sql2005 express edtn.
I started with a connected record (query in the properties) then altered it to a disconnected record set and I am performing updates using sprocs.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply