Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    pasin is offline Novice
    Windows 10 Office 365
    Join Date
    May 2021
    Posts
    8

    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.

  2. #17
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    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'

    Click image for larger version. 

Name:	NewStoredProcedure.JPG 
Views:	6 
Size:	44.5 KB 
ID:	45331

    In the query window: write your code to create the stored procedure (see my code examples to have a start)
    Click image for larger version. 

Name:	CreateStoredProcedure.JPG 
Views:	6 
Size:	66.0 KB 
ID:	45332

    In your access code: call the stored procedure you just created.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 02-10-2016, 10:00 AM
  2. Please help regarding bank transaction.
    By crackersphp94 in forum Access
    Replies: 2
    Last Post: 12-12-2015, 02:27 PM
  3. Transaction Log
    By gtimmies in forum Database Design
    Replies: 1
    Last Post: 05-27-2013, 03:27 PM
  4. Replies: 7
    Last Post: 11-14-2011, 05:59 PM
  5. SQL Transaction question
    By Mazdaspeed6 in forum Programming
    Replies: 4
    Last Post: 12-16-2010, 12:51 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums