Re: Query Error 3073

First, this newsgroup is about ADP and SQL-Server and has nothing to do with
ODBC linked tables. Usually, you will have more luck in getting a right
answer if you post this kind of question in a newsgroup such a
m.p.access.externaldata or m.p.a.odbcclientsvr.

In your case, probably that you have either a permission problem or the
table dbo.Users is missing a primary key. It's possible that there are
other possibilities, too but as you didn't post the structure of your table,
it's hard to tell you anything else.

One thing to try would be to relink the table in order the refresh the
metadata information. Try also to rebuild this query in a blank new MDB
file to be sure that you don't have a corruption problem with the mdb file.

Taking a look with the SQL-Server Profiler could also give you some hints on
what's going on here.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"MattyM" <MattyM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FDC7139A-10EB-44D1-A01C-48D5E9CD169A@xxxxxxxxxxxxxxxx
Hello All,

I have an Access 97 database that is updating a 2005 SQL server database
via some linked tables. I created a macro that runs 6 queries, three
delete
the info from the current table and the other three repopulate them. The
queries and macro use to work fine, but now for some reason one of the
queries is throwing the 'Error 3073: You tried to run, open, modify a
query
that isn't updatable" error message. The macro halts on execution that
specific query, and that's the only query throwing the error when run
individually. To my knowledge nothing has changed on the system so this is
really driving me batty. I've even recreated the query a couple different
ways and still get the error. The user is able to open the linked table on
it's own so that doesn't seem to be an issue.

The query that worked at one point;

DELETE dbo_Users.ID
FROM dbo_Users
WHERE (((dbo_Users.ID)<>"999"));


Anyone have any ideas? I've done a couple searches and the info I've found
hasn't really helped.

Thanks!



.

Relevant Pages

  • Re: Cant update table data from form
    ... > tables (the form is built on tables, not queries). ... to more than one newsgroup, ... If the record source of the form is a table (not a multi-table query) ...
    (microsoft.public.access.forms)
  • Re: SQL Query Invalid operation
    ... > removed though they query is than able to output something. ... > Both tables are made up of values from an oracle database and are ... The tables from which these queries are extracting data, ... You've posted this message in the "modulesdaovba" newsgroup. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do Access queries work?
    ... tables and passthrough queries. ... SQL-Server to retrieve the primary keys. ... and it will perform the criteria itself. ... When I create a query and add criteria, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Mail Merge with Access query linked to SQL tables
    ... This newsgroup is about ADP and SQL-Server and not about ODBC linked tables ... you only authenticate with the MDB file. ... I've changed the parameter query to use linked SQL Server tables and it ...
    (microsoft.public.access.adp.sqlserver)
  • Re: msaccess to mssql server automatic query conversion
    ... If you are using Access as a front-end to data stored in SQL-Server, ... If you are converting them to Pass-Through queries, ... > msaccess database to query for mssql server. ...
    (microsoft.public.access.queries)
Loading