Re: Why is this Not Updatable?

Please disregard my last message. I feel really stupid. I linked to the
Bill To Info field instead of the BillToID field.

Dugh!

Still have the the same not updateable error tho.

I do appreciate all your help and I am very sorry if I wasted any of your
time with the last post.





"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?
    ... have a Memo 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)