Linking Tables from SQL Server

[Brian]

I am developing an Access 2007 database front-end, using tables linked from
SQL Server 2005. I just recently had to update one of the tables in the SQL
Server by adding a new field. In my Access 2007 database, I deleted the link
to that table and then linked the table back in. Now, for some reason, I
cannot modify the data in that table from Access. I have no problem
modifying data from within SQL Server.

When connecting to the SQL Server, I use a .dsn file. I should note that I
have about 50 other tables linked into the Access front end from the same SQL
Server, using the same .dsn file, and I have no problem modifying data in
those tables from Access.

Any help would be most appreciated. Thanks!

Brian

 

[Jeff Boyce]

Brian

Do you get an error message when you try to modify the data? If so, please
post it.

Regards

Jeff Boyce
Microsoft Office/Access MVP