Can't Update Queries linke to SQL Tables

[tdejournett]

I am in the process of moving all my backend databases from Access to SQL Server. I have upsized all the tables but having problems with my Access Front End. I have several forms based on queries that when run, pull information from three tables. When I had the tables in Access, after running the query I could make changes/updates to the query results.

But now that I have upsized the tables to SQL, I can only view the data. I can't add, delete or make any changes. All my tables have a key field in them.

If I run a query on just one table, then I can make changes/updates.



Can anyone help?

[HiTechCoach]

If I run a query on just one table, then I can make changes/updates.

That is how I always do it. Even is Access.