Linking Tables from SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top