Solved Run-time error 3027 (1 Viewer)

[Ashfaque]

My First Db on SQL Server...

I have moved all my access tables successfully on SQL Server as BE and reconnected them all in my Access FE db then removed their prefix dbo_ to run all the queries and forms.

All my forms became read-only and producing above error.
"Cannot update. Database or object is read-only." This error appears at each of my code line at rst.Edit, rst.Addnew etc.......

I directly opened those linked tables in db that also looks read-only.

Can someone let me know if there is some imp thing I forgot to do it?

Thanks,
Ashfaque

 

[arnelgp]

You must Put a Primary Key to each table.

 

[Ashfaque]

You must Put a Primary Key to each table.

Thanks Arnel,

I tried adding primary key for one table and related form is working..I will add PK to all tbls.

Thanks for your support.....