I have had an Access Front End linked to SQL Server Database Tables that has been working fine.
All of the sudden I cannot alter data in those tables.
Any suggestions?
I have had an Access Front End linked to SQL Server Database Tables that has been working fine.
All of the sudden I cannot alter data in those tables.
Any suggestions?
Are you in charge of the SQL Server Database Tables?
If not, it may be that the SQL Server DBA or management has modified the characteristics of those tables or has put some constraint on your account.
We really need more info on your environment and the players involved.
Good luck.
Also, go into design mode in Access and select a SQL table, see if you can directly add a record or change a field. If you can that SQL probably ok. If not, maybe try the Link Manager and relink all the SQL tables.