Hi.
I am old to MS access / vba, but new to sql server. I tried to "export" a table to sql server from access and then link in access. It is read only to access. Then I tried to import from sql server and the linked table is still read only to access. I had a friend help me create a table on sql server... that one is read/write when linked to access.
For the import / export exercises, I can edit the tables from SSMS but not access
What am I doing wrong? Any way to change the tables so I can edit in access?
It is so much easier to import/export than create a query!
Thanks!
Steve
Harrisburg, PA