Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,273

    good luck!

  2. #17
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    655
    Hi, I am a SQL server DBA and would advise strongly against triggers here. They kill your performance and cause a lot of troubles in the front end apps.
    Data integrity should be ensured by creating the correct table structure and contraints: PK's, FK's and not null or unique constraints in your indices. See also advice #9 from Avril.
    You can also use procedures where you wrap the actions within transactions and use the try/error to rollback where necessary.

  3. #18
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    644
    Understood. Thank you for your feedback!

    Still having fun learning sql server. I just discovered CTE and cross/outer apply... Cool stuff!

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

Similar Threads

  1. Foreign keys
    By Accessuser67 in forum Access
    Replies: 1
    Last Post: 10-05-2015, 06:33 PM
  2. primary and foreign keys?
    By themebuddies in forum Access
    Replies: 1
    Last Post: 12-14-2014, 09:23 PM
  3. Replies: 2
    Last Post: 07-15-2014, 10:39 AM
  4. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  5. Need help with foreign keys
    By acdougla17 in forum Access
    Replies: 1
    Last Post: 09-26-2011, 03:50 PM

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 - Senior Forums