Recordset not updateable - Again 1

[biffer711]

I'm running Access 2000 and connecting to a database on SQL Server 7.0.

I bring up the .adp file that I'm working on and open one of the tables. Whenever I try to update any of the data I get the "Recordset is not updateable" message.

I brought this database over from the client site by generating SQL scripts to create the tables and exporting and then importing the data in CSV format.

It's not that I don't have permissions set on the SQL Server as I am able to delete the file. I have checked the permissions for each of the files and I do have SELECT, INSERT, UPDATE and DELETE permissions set.

Any help would be appreciated.

Biff

 

[allanon]

We created a large access app here and encountered that many times while develpoing out SQL 7.0 database connection. Most of the time that this occurs it was because the SQL 7.0 table (Or at least one of them) that we linked to did not have a Key. Make sure that all of your SQL 7.0 tables have a key and this should fix the problem.

 

[biffer711]

That was an immediate fix! Once the Key field was set I was able to update.

Thanks Allanon