Re: Operation must use an updateable query

Does the table in SQL server have a field of the type TIMESTAMP in it?

In most cases, the table must have such a field if you are going to UPDATE
the table using an ODBC connection from Access.

IF all the data exists on the SQL Server, you could try using a pass through
query or just do the update in on the server using T-SQL.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"RL" <RL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14D141F4-4701-4195-B0F9-0403559A6BA1@xxxxxxxxxxxxxxxx
When I run an update query within Microsoft Access 2007, the following
error
message appears:
'Operation must use an updateable query'.

Background:

The update query is part of a tool with an Access 2007 front end. The tool
contains several links to tables containing the underlying data. These
tables
used to be in another Access 2007 database but I am in the process of
moving
the underlying data from Access 2007 to SQL Server 2005.

So far I have recreated the tables in SQL Server 2005 and redirected the
links to the equivalent SQL tables.

I am logged into Windows as a user with administrator rights. The ODBC to
the SQL database connects using Windows authentication. My Windows login
name
is associated with the dbo user in the datatbase that I am linking to.

The update query attempts to update one field for various records of one
table.

Any ideas what I'm doing wrong?


.

Relevant Pages

  • Re: Local tables vs. linked
    ... automatically it's created in the SQL server. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. ... Ha eliminado 857 correos spam hasta la fecha. ... Then using a update query you can populate the ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Updating an SQL table from an Access form
    ... different table within the SQL Server. ... IIf is highlighted and the error is "Argument not optional". ... "PJFry" wrote: ... need to run an update query to change the values. ...
    (microsoft.public.access.formscoding)
  • Re: An update query through VBA
    ... > I'm using a Access 2003 client to connect to a SQL server where all the ... > I've noticed that I probably need a stored procedure to do an update ... > The update query would look something like this: ... > This would be the code executed from the VBA in a MDB solution, ...
    (microsoft.public.access.adp.sqlserver)
  • An update query through VBA
    ... I'm using a Access 2003 client to connect to a SQL server where all the data ... I've noticed that I probably need a stored procedure to do an update query, ... This would be the code executed from the VBA in a MDB solution, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
    ... IIF is an Access function it will fail in SQL Server, ... In SQL Server IsNull requires two parameters the first is teh var/field to ... > In the criteria of one of our update query fields, ... > FROM VSel INNER JOIN RenArch ON VSel.SSN = RenArch.SSN ...
    (comp.databases.ms-access)