Welcome to SPN

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

Sign Up Now!

One big Access mess...

Discussion in 'Information Technology' started by NeoDude0, Jul 28, 2006.

Tags:
  1. NeoDude0

    NeoDude0
    Expand Collapse
    Guest

    My "job" for this summer is to work on an Access database to track
    information about first responders or people with skills that could be
    useful in a crisis. The catch is, my goal is to not have to enter that
    information myself. What I'm supposed to be doing is creating a way for
    people to get into the database and access only their own record in the
    table of people, and then having one or more "administrator" sign-in
    accounts that have full access. My current server hosting is running Linux,
    so I'd be stuck with mySQL, but I may be able to get a Windows hosted
    package if I need to. Is there any way this can be done?
     
  2. Loading...

    Similar Threads Forum Date
    Politics Principles & Practices: Big Tent Revisited Blogs Aug 7, 2016
    Hard Talk Racists And Bigots Are Amongst Us . How Would You Have Reacted ? Hard Talk Jul 25, 2016
    Sikh News Big-hearted Sikh Bikers Raise $100K To Fight Pediatric Cancer Breaking News Jul 19, 2016
    A Dream SO BIG , I Am Scared To See It Relationships Apr 15, 2016
    A Great Man Makes Others Feel Big, Not Small... Sikh Sikhi Sikhism Apr 1, 2015

  3. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    Access runs on the local machine. It does NOT run on the server. The
    server is used ONLY to store the file so it doesn't matter what OS the file
    server is running. You can use Access(Jet), MySQL or what ever you want for
    the back end. MySQL runs on the server but Access runs locally.


    "NeoDude0" <alanbunting@hotmail.com> wrote in message
    news:1E5EE6A2-E5CC-4CBB-B6AA-AFE1BBE1876A@microsoft.com...
    > My "job" for this summer is to work on an Access database to track
    > information about first responders or people with skills that could be
    > useful in a crisis. The catch is, my goal is to not have to enter that
    > information myself. What I'm supposed to be doing is creating a way for
    > people to get into the database and access only their own record in the
    > table of people, and then having one or more "administrator" sign-in
    > accounts that have full access. My current server hosting is running
    > Linux, so I'd be stuck with mySQL, but I may be able to get a Windows
    > hosted package if I need to. Is there any way this can be done?
     
  4. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    NeoDude0

    > .... What I'm supposed to be doing is creating a way for
    > people to get into the database and access only their own record in the
    > table of people, and then having one or more "administrator" sign-in
    > accounts that have full access



    In Access, this is a pretty tall order.

    If you were to use Access mdb as a backend, one of the ways to handle this
    to implement the Access User Level Security (ULS) and use RWOP queries.
    Access ULS is not for the faint of heart, you would need to invest
    significant time to do it correctly. Browse the ms-access security for more
    information.

    If you were to use a back end other than Access, you would obviously have to
    learn how to implement this within the chosen backend. Each back end has its
    own way of implementing what you're asking for.


    HTH,
    Immanuel Sibero



    "NeoDude0" <alanbunting@hotmail.com> wrote in message
    news:1E5EE6A2-E5CC-4CBB-B6AA-AFE1BBE1876A@microsoft.com...
    > My "job" for this summer is to work on an Access database to track
    > information about first responders or people with skills that could be
    > useful in a crisis. The catch is, my goal is to not have to enter that
    > information myself. What I'm supposed to be doing is creating a way for
    > people to get into the database and access only their own record in the
    > table of people, and then having one or more "administrator" sign-in
    > accounts that have full access. My current server hosting is running

    Linux,
    > so I'd be stuck with mySQL, but I may be able to get a Windows hosted
    > package if I need to. Is there any way this can be done?
    >
     

Share This Page