Re: Why is this Not Updatable?


"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: UP -- patent restricted?
    ... some poor unsuspecting schmuck. ... Maybe there are capabilities in SQL that I'm totally ignorant of. ... After doing that I'd like to "ride the B-tree index" to visit and check all the entries for this client. ... When you need so many keys, i.e. you have so many functions, so much functionality, you don't have a lot of freedom to conform with what others have done. ...
    (comp.databases.pick)
  • Re: UP -- patent restricted?
    ... The schmuck won't be unsuspecting, and 4GL sounds a bit grandiloquent, ... narration) to correct a spelling error, doing it with SQL, at least at ... check all the entries for this client. ... When you need so many keys, i.e. you have so many functions, so much ...
    (comp.databases.pick)
  • Re: Identity Wert unter SQLServer 2005 abfragen
    ... Parametern aufzurufenund einen Wert vom SQL Server zurückzuerhalten, ... Oder auch ein TSQL Statement direkt an den SQL Server zu ... Methods and constants added in the JDBC 3.0 API make it possible to retrieve these keys, ... The second step is to access the generated keys by calling the Statement method getGeneratedKeys. ...
    (microsoft.public.de.sqlserver)
  • Re: Identity Wert unter SQLServer 2005 abfragen
    ... Parametern aufzurufenund einen Wert vom SQL Server zurückzuerhalten, ... Oder auch ein TSQL Statement direkt an den SQL Server zu ... Methods and constants added in the JDBC 3.0 API make it possible to retrieve these keys, ... The second step is to access the generated keys by calling the Statement method getGeneratedKeys. ...
    (microsoft.public.de.sqlserver)
  • Re: sql browser registry access
    ... >> the sql browser account to the SQLServer2005SQLBrowser$SERVERNAME local ... >> keys?? ... >>> SQL Server Encryption Software ...
    (microsoft.public.sqlserver.security)
Loading