Question Upsizing to SQL

[essexboy71]

I have just upsized my backend database tabels to SQL.

Once i link to the new SQL tables within Access, some of them are Read-only.

Can anyone explain why that may be, please?

 

[Minty]

Have you set the correct table permissions on the SQL Server?

 

[essexboy71]

Yes, i have full permissions to the tables and can delete fine if i run a query within SSMS

 

[Minty]

Have you refreshed the links to the tables since the permissions were changed?
And from memory you don't need permissions set correctly in SSMS to make queries run from the console.

 

[essexboy71]

Yes i have.

I have been assured by the SQL guys here, that the problem lies with Access

 

[Minty]

Hmm odd, you can see and open the table in datasheet view but only in read only state...
might be worth checking the ODBC setup, not really got any other suggestions

 

[pbaldy]

The tables in SQL Server need primary keys to be editable from Access, so I'd check that.

 

[GinaWhipp]

Late to the party but can't hurt, have a look here...
http://regina-whipp.com/blog/?p=371