I am new to SQL Server.
We are converting the back end of a legacy MDB to SQL Server tables.
I was successful in converting the back end data MDB to a SQL Server database using SQL Server migration assistant.
Then I linked all of the SQL tables to the Front end MDB, replacing the tables that used to be linked to Access.
All is well, except I can't revise data in any of the tables. I have been able to add new records to the tables but no revisions.
I have tried using VBA query as in this code:
updateString = " Update tblTaxRecs" & _
" Set [Active_YN] = True " & _
" Where [TaxYear] = 2014 " & _
" AND [BRT] In (Select [BRT] From tblRpt_BRTPrintList_Local ) "
I get a runtime error 3073, Operation must use an updatetable query.
I have also tried opening the table directly by double clicking on it. The data shows but I can't change any of it.
Is this some security or permissions that must be set up in SQL Server or Access.