Changing Linked Tables Makes Them read only?

[knovak]

I have linked Access2k tables to a SQL7 backend. They were pointing to a dev ODBC connection. I went into the Linked Table Manager and checked 'Always prompt for new location'. I then chose the prod ODBC connection.

Now when I try to edit the data, I get a 'Recordset is not updatedable error'. I could edit the record set before I changed the ODBC connection and nothing else has changed. I wanted to be able to switch between dev and prod environments for testing.

I'm able to reproduce this with a test database and 1 table. Why are my recordsets read-only when I switch to prod? WHen I switch back to dev, they are still read-only.

Thanks,

Kyle

 

[tlbroadbent]

In order for the SQL table to be updateable in Access it must have one at least of the following.

1) a primary key
2) a unique index
3) a timestamp column Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[stormtrooper]

Usually when linked to odbc, it's the DBA who can grant permissions on the recordset. That is, you should not be able to edit records through Access unless the DBA set the permissions to do so. Now I'm thinking dev=development and prod=production which is why you can edit in dev.

Are you running a query? If so, you can use the make table function with the data from prod. This new table will be editable.