Re: Why sql Server automatically change my input value.

From: oj (nospam_ojngo_at_home.com)
Date: 08/05/04 

Date: Wed, 4 Aug 2004 23:08:45 -0700

Amy,

Can you repro the problem using Query Analyzer? If not, you might want to post
this to Access group to see if there is something wrong with the client app.
Also, check to see if the table(s) have any triggers. There might be something
wrong with the trigger codes.

"Amy Tex" <AmyTex@discussions.microsoft.com> wrote in message
news:8CD355B8-5F6D-47E9-B09F-B1D6982259CA@microsoft.com...
> I have a column, type varchar(1000). I use access project as interface to
interact with sql server. When I input value into the column, the server change
my input. It only store the first 100 something characters right. After that,
it replaces my input with the first 100 characters. Basically, it repeat my
first several sentences. Can anybody tell me why and how I should avoid this
problem? I really appreciate your help.
>
> Amy

Relevant Pages

  • Re: Run an Access macro__
    ... Yep, I don't think it is particularly good idea, and an Access group ... threads, using the command line and object automation, so maybe you ... DTS - http://www.sqldts.com ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: MS GRAPH, PASSING PARAMETERS, ACCESS PROJECT
    ... You probably will have a better chance to get a good answer if posting to an Access group. ... a SQL Server group.) ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Moving data from Access to SQL Server
    ... How does this involve DTS? ... You may want to try posting to a VB And/Or Access group instead ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Replicate SQL Server to Access using JRO
    ... it is related to SQL Server too...and access group is just as helpful ... >> Private Sub replicate(ByVal SQLConnection As String, ByVal JetConnection ...
    (microsoft.public.access.replication)