link table in Access database is locked. I can not edit the table.
I have database created in SQL server 2005 and linked tables in Access database. I can view all the link tables in access database but i can not edit any tables. If i edit table in SQL Server then i can see the changes in Access link table.
I want to be able to make changes from Access tabes. I have form that is using lunked table to edit information. I can pull up information in the form but can not make any changes.
I know it is possibel i just cant remember how to do it.