Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

specify that a database can only be opened with access

Discussion in 'Information Technology' started by stumped_in_michigan, Nov 18, 2005.

  1. stumped_in_michigan

    stumped_in_michigan
    Expand Collapse
    Guest

    How can I specify that a database can only be opened with Microsoft Access?
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    What type of database? What other options exist for the user to use?

    --

    Ken Snell
    <MS ACCESS MVP>

    "stumped_in_michigan" <stumped_in_michigan@discussions.microsoft.com> wrote
    in message news:93B099D1-CEFE-4FCB-95B6-61C582C4D76B@microsoft.com...
    > How can I specify that a database can only be opened with Microsoft
    > Access?
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "stumped_in_michigan" <stumped_in_michigan@discussions.microsoft.com> wrote
    in message news:93B099D1-CEFE-4FCB-95B6-61C582C4D76B@microsoft.com...
    > How can I specify that a database can only be opened with Microsoft
    > Access?


    There is no Access-compatible database product that can open an Access
    database and work with it, but Access/Jet databases' data can be read using
    the DAO or ADO libraries, or some open-source readers.

    You can "open" an Access/Jet database with Microsoft Word, to dire
    results -- unrepairable corruption. For this particular thing, Michael
    Kaplan has something on his http://www.trigeminal.com site.

    If you'll tell us what you had hoped to accomplish by this, perhaps someone
    can suggest another solution.

    Larry Linson
    Microsoft Access MVP
     
  5. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    There is no 100% reliable way to do this, and I rather doubt that there is
    any 75% reliable way. You can use JET security to make it somewhat more
    difficult for the average user to access the data other than via Access, but
    given the user name, password, and location of the workgroup information
    file, any moderately knowledgeable person can get at the data via other
    applications, such as Excel.

    --
    Brendan Reynolds

    "stumped_in_michigan" <stumped_in_michigan@discussions.microsoft.com> wrote
    in message news:93B099D1-CEFE-4FCB-95B6-61C582C4D76B@microsoft.com...
    > How can I specify that a database can only be opened with Microsoft
    > Access?
     
  6. peregenem@jetemail.net

    peregenem@jetemail.net
    Expand Collapse
    Guest

    stumped_in_michigan wrote:
    > How can I specify that a database can only be opened with Microsoft Access?


    Use security to grant and revoke permissions to users and groups. You
    should be able to fake an 'application role' by hard coding a user ID
    and password in the Access application. If you have an issue with users
    without permissions using your data then you should probably not be
    using Access/Jet.

    That said, is your data/database is any good, why restrict it to a
    single front end application? It is good practise to at least provide
    PUBLIC views of the data (i.e. a VIEW a.k.a. Query Object with SELECT
    permissions) and ideally PUBLIC procedures (i.e. a PROECDURE a.k.a.
    Parameter Query, again with SELECT permissions which is not always
    intuitive e.g. when the underlying command is an UPDATE then UPDATE
    privileges are insufficient). The idea is that if you provide
    controlled ways for non-Access users to read/write data then they will
    have less incentive to attempt to circumvent security.

    For SQL DDL commands relating to permissions, see:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page