Re: Operation must use an updateable query

Thanks John.

Some of the data exists in Access and some of the data is stored in SQL
Server.

Each user will have a local copy of the Access front end, which essentially
contains cache tables where anything the user does is temporariliy stored.
Certain actions trigger update queries which move the data from the cache
tables and updates the server data.

Does that rule out the second option?

In response to your first query, no the SQL server table does not currently
contain a timestamp field. If I add that as an additional field within the
table that I'm trying to update, do you think that would resolve the issue?

RL

"John Spencer" wrote:

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: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... if your server doesn't have much memory ... and the "executing query" ball just kept ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... SQL Server MVP ... This is a dev server so I hadn't even been ... When I get properties for the FT catalog, ... I just ran a similar query on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)