AmishElectrician
New member
- Local time
- Today, 08:32
- Joined
- Jul 13, 2021
- Messages
- 3
The company I just started working for has an Access database they have been maintaining for years. They have tasked me with converting the BE to SQL. My knowledge is very limited but I do understand basic concepts of VB and database management.
After having converted the tables to SQL I am, of course, having trouble with the VBA code. On a few of my forms I am getting the following error when opening them in Form View:
"Unexpected error: Error number 3622 - You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column."
Obviously the error is telling me how to fix it, so after seeing a few threads here I added dbSeeChanges to my OpenRecordset and Execute commands. The form still opens with the 3622 message, however.
Maybe I am missing something somewhere? Is there something in the interface I need to check in addition to the VBA? The form's Property sheet has a query defined for Record Source if that needs to be looked at. My knowledge of Access is very limited so I might be missing a simple thing.
I have attached the code for the entire form.
After having converted the tables to SQL I am, of course, having trouble with the VBA code. On a few of my forms I am getting the following error when opening them in Form View:
"Unexpected error: Error number 3622 - You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column."
Obviously the error is telling me how to fix it, so after seeing a few threads here I added dbSeeChanges to my OpenRecordset and Execute commands. The form still opens with the 3622 message, however.
Maybe I am missing something somewhere? Is there something in the interface I need to check in addition to the VBA? The form's Property sheet has a query defined for Record Source if that needs to be looked at. My knowledge of Access is very limited so I might be missing a simple thing.
I have attached the code for the entire form.