Unable to insert data into my backend SQL Database from MS Access FE

[Adict]

I have recently, migrated all my table from ms access .mdb into SQL Server 2012. I have relinked all the tables successfully and can view the records. However, i am unable to write back into SQL Database from all my access forms. I have tried looking all treads here but none of them is helping. Appreciate any input and feedback. All my forms are bound to dbo_tables.

[NeoPa]

This looks like it needs a procession of steps to determine what's going wrong.

The first step would be to check that the linked tables you're using allow you to update data.

[Adict]

Thanks NeoPa _ i am looking at some threads to assist me with this but still not getting it right. I am now thinking of recreating the tables from within SQL as the current tables where migrated from .mdb file to sql server.

[NeoPa]

You have your own thread now with a suggestion in it. Where have you got with that first step (You've responded already but haven't dealt with the first step as suggested.)?

It will be very difficult to proceed unless you deal with what gets posted.

[Adict]

Thanks Neopa - i realized that at the SQL back-end tables i had the table as read only so i changed that and i was able to insert into the table. I simply inserted a new column in sql tables with an int identity(1,1) datatype and it all worked.

[NeoPa]

Very pleased to hear it :-)

Sometimes those simple steps can help you find the answer in very short shrift. Sometimes they're more complicated, but not necessarily.