Can you please explain me more what you just wrote. Have I done sth wrong in my
code or it is normal behaviour for sql server and access? The code I wrote works fine if it is out of trnsaction.
Can you please explain me more what you just wrote. Have I done sth wrong in my
code or it is normal behaviour for sql server and access? The code I wrote works fine if it is out of trnsaction.
Hi Pasin,
if you want to work with transactions on SQL server, that's fine: it was made for that. So what I want to say: write your code in SQL server and call the SQL server procedure from access.
To create a procedure on SQL server:
- Open the SSMS (management studio) on SQL server
- Click the database node open from the database you want to use
- Click the Programmability node open
- Right click Stored Procedures and choose 'New Procedure'
In the query window: write your code to create the stored procedure (see my code examples to have a start)
In your access code: call the stored procedure you just created.