Hello All,
This is a repost for a question I apparently put in a wrong forum
originally. I'm reposting here to see if anyone has any ideas.
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 tables 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"));
The SQL Server table that the query in question deletes data from has a
primary key, it can be have data appended to it from an Access query (one
of
the 6 I talked about above), and can be opened directly as a linked table
in
access. I checked permissions on the table in SQL and they're is the same
as
the other tables that aren't having issues. I can't find anything that
changed, yet now it throws errors.
Anyone have any ideas? I've done a couple searches and the info I've found
hasn't really helped. If anyone has an idea it'd be greatly appreciated as
this is getting rather frustrating.
Thanks for your help!
|
