Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Determine file dependency (access97)

    How do you properly determine the file dependency one database has on another? Meaning if a database is split into a front end & back end, how can I verify the connection between the two? I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Determine file dependency (access97)

    In code or in the UI? In the UI, open one of the linked tables in design view and then open the properties dialog. The Description property will give you the connection information on a linked table.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Determine file dependency (access97)

    In code you can use:
    = currentdb.tabledefs("yourtablename").connect
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    2 Star Lounger bobdog's Avatar
    Join Date
    Jan 2001
    Posts
    108
    Thanks
    3
    Thanked 5 Times in 4 Posts

    Re: Determine file dependency (access97)

    This might be a dead thread, but this may help:

    A problem you might run into with split databases is to keep users out of the back end db. You can do this by opening a modal "go away" screen ("This database is restricted and is intended to be...yadda, yadda") with only one OK button at the bottom that simply closes the db and exits Access.

    It won't stop a coder (holding the shift key on open prevents the form from opening), but it keeps peekers and pokers away from your tables and relationships. If you want to be tricky about it, you can log startups to a table and review it from time to time.

    Had this problem with an app I wrote for a small state university. Turned out there were more users that had access to our application than the techies thought. This cured it.

    Hope it helps.

Posting Permissions

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