Welcome to SPN

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

Sign Up Now!

updating access

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

  1. melscholten

    melscholten
    Expand Collapse
    Guest

    I am looking for the best source of data storage and need to have the
    information stored in mutliple formats. As of now, it appears that Access is
    my best option, however I want to make sure.... So, if I change a field in
    one instance in Access, will it change all recurrances?
     
  2. Loading...


  3. ChrisM

    ChrisM
    Expand Collapse
    Guest

    "melscholten" <melscholten@discussions.microsoft.com> wrote in message
    news:3F17E8E5-94AC-43E4-93B5-5AD2F9A34AFB@microsoft.com...
    >I am looking for the best source of data storage and need to have the
    > information stored in mutliple formats. As of now, it appears that Access
    > is
    > my best option, however I want to make sure.... So, if I change a field in
    > one instance in Access, will it change all recurrances?


    What exactly do you mean by 'So, if I change a field in one instance in
    Access, will it change all recurrances?'

    If you make a change to a field in an Access database then that change will
    affect any application that uses that database. It will not change any
    fields in any other Access databases though.
    Having said that there is somthing called 'Replication' that does somthing
    along those lines...
     
  4. melscholten

    melscholten
    Expand Collapse
    Guest

    What I mean by 'So, if I change a field in one instance in Access, will it
    change all recurrances?' requires more explanation than I initially
    provided...
    I am creating a database which needs to be sorted by two different filters
    and exist as two seperate entities as such for accessability. However, the
    information will need to be updated and I am wondering if there is any way to
    only have to update it in one location and have it automatically update the
    other citation of it...

    "ChrisM" wrote:

    >
    > "melscholten" <melscholten@discussions.microsoft.com> wrote in message
    > news:3F17E8E5-94AC-43E4-93B5-5AD2F9A34AFB@microsoft.com...
    > >I am looking for the best source of data storage and need to have the
    > > information stored in mutliple formats. As of now, it appears that Access
    > > is
    > > my best option, however I want to make sure.... So, if I change a field in
    > > one instance in Access, will it change all recurrances?

    >
    > What exactly do you mean by 'So, if I change a field in one instance in
    > Access, will it change all recurrances?'
    >
    > If you make a change to a field in an Access database then that change will
    > affect any application that uses that database. It will not change any
    > fields in any other Access databases though.
    > Having said that there is somthing called 'Replication' that does somthing
    > along those lines...
    >
    >
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 10 Jul 2006 10:59:01 -0700, melscholten
    <melscholten@discussions.microsoft.com> wrote:

    >What I mean by 'So, if I change a field in one instance in Access, will it
    >change all recurrances?' requires more explanation than I initially
    >provided...
    >I am creating a database which needs to be sorted by two different filters
    >and exist as two seperate entities as such for accessability. However, the
    >information will need to be updated and I am wondering if there is any way to
    >only have to update it in one location and have it automatically update the
    >other citation of it...


    You should NOT store the same data redundantly in two places.

    As a relational database, you should instead store it ONCE; you can
    then display it as many different places (Forms, Reports, queries) as
    you wish, all linked to the same table.

    Note that Tables *have no order* - they should be viewed as an
    unordered "heap" of records. If you want to see the records sorted or
    filtered (which are two different operations!!!) you can use Queries
    based on the table.

    John W. Vinson[MVP]
     
  6. melscholten

    melscholten
    Expand Collapse
    Guest

    i figured out what i was trying to do....
    i did a table with seperate forms to have the information organized in
    different manners for accessibility and appropriate usage.

    "John Vinson" wrote:

    > On Mon, 10 Jul 2006 10:59:01 -0700, melscholten
    > <melscholten@discussions.microsoft.com> wrote:
    >
    > >What I mean by 'So, if I change a field in one instance in Access, will it
    > >change all recurrances?' requires more explanation than I initially
    > >provided...
    > >I am creating a database which needs to be sorted by two different filters
    > >and exist as two seperate entities as such for accessability. However, the
    > >information will need to be updated and I am wondering if there is any way to
    > >only have to update it in one location and have it automatically update the
    > >other citation of it...

    >
    > You should NOT store the same data redundantly in two places.
    >
    > As a relational database, you should instead store it ONCE; you can
    > then display it as many different places (Forms, Reports, queries) as
    > you wish, all linked to the same table.
    >
    > Note that Tables *have no order* - they should be viewed as an
    > unordered "heap" of records. If you want to see the records sorted or
    > filtered (which are two different operations!!!) you can use Queries
    > based on the table.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page