Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Tables (97)

    Hi all, just a quickie.

    I have a frontend which has linked tables to the backend database. I have just thought it may be a good idea to protect the backend with a password, but this obviously disallows my linked tables to be accessed from the frontend.

    Can I code for this? To make the linked tables automatically give the password?

    <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked Tables (97)

    1. Set the password on the backend.
    2. Delete the linked tables in the front end (naturally, this does not affect the data in the back end.)
    3. Select File | Get External Data | Link Tables
    4. When you select the backend, you will be prompted for the password.

    From that moment, the linked tables are available until you change the password again. You'll have to repeat steps 2 through 4 then.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Tables (97)

    <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

    NIce one. I should have thought to try that really! Thanks.

    An extra question:

    When I look at the relationshi[s window in the frontend where the (now working nicely with the password) linked tables are, the relationships between them are not shown.

    I know they are there in the backend, just wondering if there is any (perhpas speed) advantage with recreating the relationships in the frontend. I can see I wont be able to enforce integrity there, but should i make plain relationships there too?
    Thanks,

    pmatz

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked Tables (97)

    I hadn't noticed that before (apparently it is a side effect of the password), but even though the relationships are not displayed in the frontend, relational integrity still is enforced in the frontend if it was set in the backend.

    By the way, setting a database password is not very secure, you can get password crackers on the web. Applying user-level security with a secured workgroup information file is more robust. See The Secrets of Security on <!profile=WendellB>WendellB<!/profile>'s website.

  5. #5
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Tables (97)

    Thanks Hans, I will have a look at that now.

    How good are you at tab controls... im finding it annoying that the dont 'really' go transparent!
    Thanks,

    pmatz

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked Tables (97)

    (Tabs are actually a subject for a new thread.) If you set the Back Style property of a tab control to Transparent, only the interior of the tabbed pages will be transparent. The strip containing the tabs is not transparent, its color is governed by the Display Properties control panel, not by Access. You can make the border of the tab control transparent by setting the Type property to Buttons instead of Tabs. If you set the Style property to None, the entire tab control will be transparent, but you will have to handle switching between tab pages yourself, in code.

  7. #7
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Tables (97)

    Sorry, if I have any more Q's i will make a new thread. Thanks again Hans.

    Wendall's site is cool

    [img]/forums/images/smilies/smile.gif[/img]
    Thanks,

    pmatz

Posting Permissions

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