I have migrated MS Access db to SQL Server 2008 and come across 'identity' errors and I found out that I just need to change connection type,option so:
Before migration: CurrentDb.Execute ("update tbl set field = 1")
After fix is applied: CurrentDb.Execute "update tbl set field = 1" , dbSeeChanges + dbFailOnError
In the application I got there are hundreds of places where it needs changing so I'm after an easy solution. I used find replace on similar examples where the code was variable but in this case I need to find the line starting with 'Currentdb.execute (' and remove ( and replace closing ) at the end of line with ', dbSeeChanges + dbFailOnError'
Any ideas how to do that? I think there is a way to amend code in VBA dynamically which I think might work I also could export everything and run some VBA on the export files but what I'm after is quick and realiable way(manual interventioned reduced to minimum) to make the changes so I can also repeat it in the future (I will have to perform migration again in the near future once FE changes are finished)
Many thanks in advance