423,491 Members | 2,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,491 IT Pros & Developers. It's quick & easy.

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

P: 11
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.
May 21 '18 #1

✓ answered by 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.

Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,037
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.
May 21 '18 #2

P: 11
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.
May 21 '18 #3

NeoPa
Expert Mod 15k+
P: 31,037
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.
May 21 '18 #4

P: 11
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.
Jun 11 '18 #5

NeoPa
Expert Mod 15k+
P: 31,037
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.
Jun 12 '18 #6

Post your reply

Sign in to post your reply or Sign up for a free account.