Welcome to SPN

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

Sign Up Now!

Limitation of Access

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

  1. Neon520

    Neon520
    Expand Collapse
    Guest

    Is there anybody could tell me: What is the limitation of MS Access?

    Best Regard,
    Neon520
     
  2. Loading...


  3. kerry_ja@yahoo.com

    kerry_ja@yahoo.com
    Expand Collapse
    Guest

    There are different limits depending on what you are referring to. Can
    you be more specific? For example, Access is limited to 255 columns in
    a table or query (At least until the next version is released). Try
    going to help and entering Access specifications. That should let you
    find the limits for your version.
     
  4. BruceM

    BruceM
    Expand Collapse
    Guest

    It depends on what you are trying to do. Is your question related to a
    particular issue or set of issues?

    "Neon520" <Neon520@discussions.microsoft.com> wrote in message
    news:C1A7F88E-E789-44E9-B51E-630B0C3606B2@microsoft.com...
    > Is there anybody could tell me: What is the limitation of MS Access?
    >
    > Best Regard,
    > Neon520
     
  5. Neon520

    Neon520
    Expand Collapse
    Guest

    What I am trying to refer to is that Access is a database program, which also
    contain some programming language inside. My question was what is the
    limitation of MS Access, regarding as far as its programming limitation?
    Cause I wonder if Access could also do the same job that some program sold in
    the market, why not just use Access to set up what you need, instead of
    spending extra money on some of the programs sold in the market today (which
    sometime is really not as effective as what we really need/want)
    Thank you,
    Neon520


    "kerry_ja@yahoo.com" wrote:

    > There are different limits depending on what you are referring to. Can
    > you be more specific? For example, Access is limited to 255 columns in
    > a table or query (At least until the next version is released). Try
    > going to help and entering Access specifications. That should let you
    > find the limits for your version.
    >
    >
     
  6. Neon520

    Neon520
    Expand Collapse
    Guest

    Hi Bruce,
    What I am trying to refer to is that Access is a database program, which also
    contain some programming language inside. My question was what is the
    limitation of MS Access, regarding as far as its programming limitation?
    Cause I wonder if Access could also do the same job that some program sold in
    the market, why not just use Access to set up what you need, instead of
    spending extra money on some of the programs sold in the market today (which
    sometime is really not as effective as what we really need/want)
    Thank you,
    Neon520


    "BruceM" wrote:

    > It depends on what you are trying to do. Is your question related to a
    > particular issue or set of issues?
    >
    > "Neon520" <Neon520@discussions.microsoft.com> wrote in message
    > news:C1A7F88E-E789-44E9-B51E-630B0C3606B2@microsoft.com...
    > > Is there anybody could tell me: What is the limitation of MS Access?
    > >
    > > Best Regard,
    > > Neon520

    >
    >
    >
     
  7. BruceM

    BruceM
    Expand Collapse
    Guest

    I'll keep the conversation to this thread. There are off-the-shelf programs
    to take care of many situations such as financial management. It is often a
    better investment to spend the money rather than take the time to develop
    your own application. However, it's not all-or nothing. There are Access
    databases that can be used as templates to produce your own database. I
    believe some are available on the Microsoft web site. Unlike purchased
    programs, these template databases can be customized.

    A big consideration with Access is the learning curve. You need to learn
    the basics of relational database design, then learn how to implement a
    design for your specific situation. You can open Word for the first time
    and produce a passable document by the end of the day, but with Access you
    may be looking at months before you have something you can use. It depends
    on the project.

    One important distinction between Access and other applications such as Word
    and Excel is that Access is a program development tool, while Word and Excel
    are programs in their own right. You can open Word and start typing, but in
    Access you need to build a table (or an unbound form, etc.) at the very
    least before you can do anything at all. Access is a versatile and powerful
    tool, and as such takes some time to learn.

    "Neon520" <Neon520@discussions.microsoft.com> wrote in message
    news:ABB5DC30-893B-402E-999E-FDC7471834A2@microsoft.com...
    > What I am trying to refer to is that Access is a database program, which
    > also
    > contain some programming language inside. My question was what is the
    > limitation of MS Access, regarding as far as its programming limitation?
    > Cause I wonder if Access could also do the same job that some program sold
    > in
    > the market, why not just use Access to set up what you need, instead of
    > spending extra money on some of the programs sold in the market today
    > (which
    > sometime is really not as effective as what we really need/want)
    > Thank you,
    > Neon520
    >
    >
    > "kerry_ja@yahoo.com" wrote:
    >
    >> There are different limits depending on what you are referring to. Can
    >> you be more specific? For example, Access is limited to 255 columns in
    >> a table or query (At least until the next version is released). Try
    >> going to help and entering Access specifications. That should let you
    >> find the limits for your version.
    >>
    >>
     
  8. Jes67 via AccessMonster.com

    Jes67 via AccessMonster.com
    Expand Collapse
    Guest

    "....some programs sold in the market...." ....??? That's pretty wide open..

    Neon520 wrote:
    >What I am trying to refer to is that Access is a database program, which also
    >contain some programming language inside. My question was what is the
    >limitation of MS Access, regarding as far as its programming limitation?
    >Cause I wonder if Access could also do the same job that some program sold in
    >the market, why not just use Access to set up what you need, instead of
    >spending extra money on some of the programs sold in the market today (which
    >sometime is really not as effective as what we really need/want)
    >Thank you,
    >Neon520
    >
    >> There are different limits depending on what you are referring to. Can
    >> you be more specific? For example, Access is limited to 255 columns in
    >> a table or query (At least until the next version is released). Try
    >> going to help and entering Access specifications. That should let you
    >> find the limits for your version.


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200605/1
     
  9. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    >why not just use Access to set up what you need, instead of
    > spending extra money on some of the programs sold in the market today



    Well, that question is no different then why not build your own furniture.
    Why purchase furniture when you can get some wood, and build your own?

    The problem is that to get really good a carpentry takes a long time, and a
    lot of effort before you reach that tipping point in which it is easier to
    purchase something then build it your self.

    It likely cost in the millions to create QuickBooks accounting, and you can
    get a version for 99 bucks. There is just no way that you can even being to
    build a product for the same cost and time in ms-access. If you are asking
    can you build an accounting system in ms-access...does it have the *ability*
    to make such a system? Why yes, you can.

    However, the skill level to create such a accounting appcation is quite
    large.

    You could also think of this whole issue much like music. Do you want to go
    down to the music shop, and purchase a record, or do you want to purchase
    some musical instruments and MAKE YOUR own music? To make good music takes
    years of practice, and writing good software is really the same.

    Any good and enjoyable software you now use on your computer was likely
    written by someone who had YEARS of experience doing this. I can't come up
    with a better example comparison then that of making enjoyable music. It
    takes years to be able to make enjoyable music, yet I can start whacking on
    a drum..and make some music...but, it will be more like noise!!! (and, I can
    assure you that your first software you create will also likely be much like
    noise also!!).

    So, you can create some really nice applications in ms-access, but you going
    to have to spend effort and time to acheive this.

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page