Results 1 to 2 of 2

Thread: Linking (2000)

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Manchester, Gtr Manchester, England
    Thanked 0 Times in 0 Posts

    Linking (2000)

    Hello, I have a number of reports that users run themselves but I want these reports to stand in an application seperate to the main database so that the users cannot access the tables, queries etc? How can I do this?

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Linking (2000)

    User-level security is the best way to limit access. Moderator <!profile=WendellB>WendellB<!/profile> has a tutorial, with useful links, about security on his website (you will find a link in his profile; look for Support > Tutorials > The Secrets of Security)

    You can combine this with a back end - front end approach, in which the back end database contains only tables, and the front end all other objects, plus linked tables that refer to the real tables in the back end. But without security, users would still be able to open tables and queries.

    If you only want to prevent users from opening tables etc. by accident, you can use the startup options (Tools |Startup...) to hide the database window etc. But this will not help against malevolent users.

    It would be a lot of work to create a standalone application in VB6, since Access reports don't work in VB6, you would have to create new reports from scratch.

Posting Permissions

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