I upgraded a local Access table to a remote SQL 2017 database.
1. The connection reads data but
2. The connection won't write data.
If I use the same User and Password I can change (update) data within the SMS
I use a vb.net front end and all was working great with MS Access locally
I use a SAVE button after making some data changes and I receive an error 5 which I have not been able to resolve. I've pasted the code behind the SAVE button below.
'Master_ContactsBindingSource.Filter = "email = '" & mTempEmail & "'"
Me.Cursor = System.Windows.Forms.Cursors.Default
Here is the connection string (READ=great, write = NO
Provider=SQLNCLI10.1;Data Source=18.104.22.168;Initial Catalog=Data_Warehouse;User ID=dw_admin;Password=***