Results 1 to 2 of 2

Thread: Access links

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access links

    Question from my boss: "if a relationship is set up between two linked SQL tables in Access, does the link affect the native database or does it only exist in the Access 'front end'?" Does this make any sense to anyone???

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access links

    If the link is established in the front end database, it is stored in the front end database.
    If you want to establish referential integrity to your database you should set up the link in the back end database and not in the front end database.

    Bart Stam
    Software designer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •