How can I extend the number of characters in MS SQL for text entry?

Hot Topic

parameter issue in with member
sp_executesql From App's Dynamic SQL Causing Performance Problems vs. Query From SSMS
Tran Log Backups Fail 40 minutes after the Differential backup.
synchronising data between SQL 2000 32 bit and SQL 2005 64 bit servers
SQL Server Enterprise
Setup replication job in cluster2005 failed with unknown user name or bad password
sql. problem sum
Upside down text
Cannot Install SQL Server 2005 Developer Edition - Configuration Tools Only
Trying to get daily totals from cumulative totals in a pivot

SQL Server

VarCharMax Stored proc parameters
Is it possible to upgrade to SP1 for my existing SQL 2005 Express edition?
the public group and do we realy need it
partitioned views Explain Plan
Multi value in Report Parameter using MSVS Report Designer.
Quick question on VB
Can't uninstall Analysis Services 2000
SP Compilation Confirmation Message?
User is not associated with a trusted SQL Server connection
Matrix Subtotals/Cells

How can I extend the number of characters in MS SQL for text entry?

Using MS Access as a front end and SQL as a back end how can i get past the 4000 character limmit per table


Answer this question

How can I extend the number of characters in MS SQL for text entry?

  • pierreg

    Thanks so much that worked fine. I am a newbee to SQL 2005 or SQL for that matter. got it working. I am posting another question how do I link tables in SQL 2005 is there a paper on this out there I am using access beta 2007 and the linked tabel feature is greyed out

  • OniShiro

    Use the TEXT or NTEXT column types in SQL Server.

    If you have SQL Server 2005 you can use the varchar(max) or nvarchar(max) types as well but I'm not sure if these work with Access or not.



  • Williamq

    Hang on I will install Access 2007 and give it a try, it should work I think.

  • Cody21

    Matt my name is Peter, when i talked about links before i was refering to "relationships" sorry i should have been more clear. I was able to fumble my way through it though. I think I am going to try some reports tonight that will tell me if they are good or not.

  • joshua926

    I installed the latest Access 2007 beta and I was able to successfully link to a SQL 2005 table using the SQL Native Client driver. It worked for me.

  • lawhornk

    What I did was:

    1. Opened Access 2007.

    2. Clicked on new blank database (then typed in name and hit Create).

    3. Clicked on External Data menu and then went under More section and selected ODBC Database.

    4. Selected Link, OK.

    5. Selected Machine Datasource tab and clicked New, setup new datasource to my SQL Server using the SQL Native Client driver.

    6. List of tables came up, then I picked the one I wanted.

    Selected table and verified it worked.



  • D--

    Thanks I have done that fine but my problem is linking the tables after that! I have solved that now also, here is my problem.

    I use MS Access 2003 to create a data access page, (I can't find a way to do a "page" in 2007) NOTE! this is a lil trick i picked up on. I can create the tables in Access 2007 on the 2005 SQL server, but not with Access 2003! but I still use Access 2003 to create my Data access pages and publish them to my website.

    I have tried Visual Studio 2005 and I can't get there from here! so I am using two versions of access.

    When I create a drop down menu in my Page I can't get it to populate the other feilds in the page. I can create / View / Edit new records fine but I need to be able to pop open a contact record by selecting a name from a dropdown list. any hints Thanks for your help by the way.



  • How can I extend the number of characters in MS SQL for text entry?
Answer this question