Re: Why is this Not Updatable?

Not understanding whats going on I deleted the linked tables and re-linked
them. I am now getting this error which might shed some light on this for
you.
Cannot join on Memo, OLE, or Hyperlink object (dbo_tblCustomers.BillToID =
dbo_tblBillToInfo.[Billing Info])

In the Access 2K tables that I imported into SQL tables both of these tables
have a Memo field. Is there something I need to do on the SQL side with
regards to the memo fields?

"Chris2" wrote:

>
> "cvegas" <cvegas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8F737424-62A6-4802-8CAB-A2B3C9980A25@xxxxxxxxxxxxxxxx
> > What is happening is that when I pull us my form Forwarders which
> is has the
> > record source as the sql query I posted earlier called [Customer
> By Number]
> > and try to update any data I get an error message in the bottom
> left side of
> > the screen that says "This Record Set is not updatable"
> >
> > It does not appear that I have any relationships set up in my
> Access front
> > end and I know I have not done any relationships on the sql server
> or if this
> > is even possible. As I said I am pretty new at this and I am
> taking over
> > from someone's elses work.
>
> cvegas,
>
> When I tried to duplicate what is happening for you, I did not set
> up any MS Access relationships, and I was still able to update the
> data.
>
> My question is, are there proper keys established on the SQL Server
> tables?
>
> If there *are* proper keys on the SQL Server tables, then when you
> go into Design View on the linked tables in MS Access (you may get a
> warning that no changes can be made), do the primary key columns
> show the "key" icon indicating that MS Access knows what the primary
> key column is?
>
> Again, I am not sure of exactly what is going on because I do not
> know what the exact table structures and keys are in SQL Server.
>
> Sincerely,
>
> Chris O.
>
>
>
.

Relevant Pages

  • Re: backup Keys
    ... "Back up the SQL Server 2005 encryption keys by using the corresponding SQL ... Regarding on the symmetric and asymmetric keys in SQL Server 2005 database, ...
    (microsoft.public.sqlserver.security)
  • Re: Why is this Not Updatable?
    ... Bill To Info field instead of the BillToID field. ... are there proper keys established on the SQL Server ... > warning that no changes can be made), do the primary key columns ...
    (microsoft.public.access.queries)
  • Re: why default index for primary key is clustered?
    ... >> So why SQL Server created clustered index by default for primary key ... When you had sequential tape files, ... A master tape would be read in sorted order ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Data Encryption In SQL2005
    ... you need to have been granted special permissions for creating keys. ... >> Mike Epprecht, Microsoft SQL Server MVP ... >>> I want to encrypt data in such a way that even DBA's who created the ...
    (microsoft.public.sqlserver.security)
  • Re: ntext getting truncated
    ... If you are seeing the truncated results in SQL Server Management Studio, or in Query Analyzer, you may be suffering from the limits of those tools. ... description of problem in the memo field. ... server fieldpart of the problem descriptioin is getting truncated. ...
    (microsoft.public.sqlserver.programming)