Query Error 3073

[MattyM]

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!

 

[Sylvain Lafontaine]

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.

 

[sharron]

so what?