MS Access to SQL server connection string

[rcsmith0712]

Hi Folks. I have an access application that is using SQL server 2019 for the backend. All of my "queries" work but when the Update and insert statements execute Access will display the append or Update warning but nothing is actually being written or changed in the SQL tables. I believe I need to establish a SQLOLEDB connection string in my access project but I am having trouble. I get a message the states "Object Required". Any assistance would be greatly appreciated. Thank you. So far my code for the connection looks like this:

Dim ConnStr As String
 
ConnStr = "Provider=SQLOLEDB;Data Source='FalconXtreme';" & _
 "Initial Catalog='SacDb';Integrated Security= TRUE;"
 
 objConn.Open ConnStr

[NeoPa]

So, from your description it's clear you're doing something wrong. What that might be is very hard to tell from the information you share. Your queries work without working :-S

Do you actually have a connection to the SQL Server in any way that allows updating of data? What are the queries working with? Don't leave us trying to guess what should be in your question.

[isladogs]

Following on from NeoPa's comments, please show an example of the code used in your update and insert SQL statements

[hilmi123]

Can you share your execution of the sql statement?

For access front and sql be, you need to change your code for execution for delete, update and insert to "dbSeeChanges"

Eg

CurrentDb.Execute sql, dbSeeChanges

[NeoPa]

Hilmi123:
For access front and sql be, you need to change your code for execution for delete, update and insert to "dbSeeChanges"

That's very true. Worth a try if you haven't already.