Hello,
I have a problem I can't figure out what is the solution.
I created a Access 2013 DB, both a front end and back end DB. I converted the back end DB to SQL Server DB.
On a form, the user has the ability to create a new record, or edit an existing record. When the user selects to edit an existing record, after editing the record, and then selecting to save, I have a pass through query that updates the record. My problem is the application is creating a new record. I then receive a Windows message about asking to save the data to the clipboard.
From what I can tell, when the record is selected to update, is their a lock being placed on this record? Could that be why it's creating a new record, rather than updating the record.
The reason I mentioned that this operated previously with an Access back end DB, is that the Front End DB was not changed when switching from Access 2013 to SQL Server.
Thanks in advance for your response.