Access or Visual Studio?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jerome

    #1

    Access or Visual Studio?

    Hi, I'm a bit confused ... when would I rather write an database
    application using MS Access and Visual Basic and when (and why) would I
    rather write it using Visual Studio .Net?

    Is it as easy in Visual Studio to create reports and labels as it's in
    Access?`

    The advantage of VS.net is that not every user needs Access, right? And
    that would eliminate the Access version problem as well I guess.

    I've both done stuff in Access as well as asp.net

    Thanks!
  • Brian

    #2
    Re: Access or Visual Studio?

    "Jerome" <nospam@nospam. com> wrote in message
    news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=blue]
    > Hi, I'm a bit confused ... when would I rather write an database
    > application using MS Access and Visual Basic and when (and why) would I
    > rather write it using Visual Studio .Net?
    >
    > Is it as easy in Visual Studio to create reports and labels as it's in
    > Access?`
    >
    > The advantage of VS.net is that not every user needs Access, right? And
    > that would eliminate the Access version problem as well I guess.
    >
    > I've both done stuff in Access as well as asp.net
    >
    > Thanks![/color]

    Access is a vastly superior development platform for database applications:
    the cost of development is far lower, and it has wonderful database-centric
    features like linked subforms and continuous forms. The only reason to use
    anything other than Access to build a database application is if you want it
    on the internet, which is something that you just can't do with Access.
    Even if you have a large user population or demanding security/resilience
    requirements, it's still best to use Access, linked to a sever database
    engine such as SQL Server.

    If you buy the Office Developer Edition, or whatever Microsoft is calling it
    these days, you can freely distribute a run-time version of Access so that
    you don't need to buy Access for all your users.


    Comment

    • Dave

      #3
      Re: Access or Visual Studio?

      Access should be used as a portible database where large amounts of data is not expected.
      SQL Server (Oracle, etc.) should be used for rooted databases where potentially large amounts of data will be used.

      VS.NET is not a database. It can connect to an instance of any ODBC database, and I believe that some (maybe all) versions of
      VS.NET ship with MSDE version of SQL Server. This is a desktop engine which allows developers to develop database code without
      having to purchase full versions of the software.

      If your planning on using the database for a website, Access is viable if there will not be large amounts of data, high performance
      is not expected in a stressful environment, security roles are not required and the benefits of T-SQL, DTC and Extended Stored Procs
      are not required.

      Otherwise, think about purchasing a more robust database server.

      For the time being, I believe you can use the MSDE version that shipped with VS.NET for development purposes.

      Hope it helps.


      --
      Dave Sexton
      dave@www..jwaon line..com
      -----------------------------------------------------------------------
      "Jerome" <nospam@nospam. com> wrote in message news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=blue]
      > Hi, I'm a bit confused ... when would I rather write an database
      > application using MS Access and Visual Basic and when (and why) would I
      > rather write it using Visual Studio .Net?
      >
      > Is it as easy in Visual Studio to create reports and labels as it's in
      > Access?`
      >
      > The advantage of VS.net is that not every user needs Access, right? And
      > that would eliminate the Access version problem as well I guess.
      >
      > I've both done stuff in Access as well as asp.net
      >
      > Thanks![/color]


      Comment

      • Cor Ligthert

        #4
        Re: Access or Visual Studio?

        Brian,
        [color=blue]
        >
        > Access is a vastly superior development platform for database
        > applications:
        > the cost of development is far lower, and it has wonderful
        > database-centric
        > features like linked subforms and continuous forms. The only reason to
        > use
        > anything other than Access to build a database application is if you want
        > it
        > on the internet, which is something that you just can't do with Access.
        > Even if you have a large user population or demanding security/resilience
        > requirements, it's still best to use Access, linked to a sever database
        > engine such as SQL Server.
        >[/color]

        How large is your team to build simultanisly applications with?

        And how you have reusability implemented with that?

        Cor


        Comment

        • Cowboy \(Gregory A. Beamer\)

          #5
          Re: Access or Visual Studio?

          Access is a monolithic approach. There are many good apps written in Access.
          But, once you start including forms, queries, etc., it is hard to divorce
          yourself from Access and move up to another backend database, like SQL
          Server, as you end up rewriting all of your code.

          If you opt for an external solution, using Access as the backend only, you
          can switch to another database without much pain.

          --
          Gregory A. Beamer
          MVP; MCP: +I, SE, SD, DBA

          *************** *************** *************** **
          Think outside the box!
          *************** *************** *************** **
          "Jerome" <nospam@nospam. com> wrote in message
          news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=blue]
          > Hi, I'm a bit confused ... when would I rather write an database
          > application using MS Access and Visual Basic and when (and why) would I
          > rather write it using Visual Studio .Net?
          >
          > Is it as easy in Visual Studio to create reports and labels as it's in
          > Access?`
          >
          > The advantage of VS.net is that not every user needs Access, right? And
          > that would eliminate the Access version problem as well I guess.
          >
          > I've both done stuff in Access as well as asp.net
          >
          > Thanks![/color]


          Comment

          • Cowboy \(Gregory A. Beamer\)

            #6
            Re: Access or Visual Studio?

            I would disagree with you on many points.

            1. Access is a horrible platform for large databases. While it can get to a
            rather large size, it is a file based DB, which means perf degrades
            horribly. I would say 50MB is a good theoretical max, although I have seen
            Access DBs in the ridiculous range.

            2. Access is great for single developers, but bad for team development. It
            is difficult to impossible to get a team working on the same solution,
            unless Access is merely a data repository.

            3. Access creates monolithic applications, which means there is little
            flexibility in distributing the work as your company grows.

            Access certainly fits a niche. It has a wonderful designer and allows you to
            leverage your work with forms, queries, reports, etc. Much of the work can
            be done without a huge amount of code. But, you pay a price, as you lock
            yourself into the Access solution. If you later outgrow, you end up
            rewriting everything.

            I am not knocking Access, as it is a great product, but it definitely has
            its limitations. Whether Jerome should use Access or not depends on his
            final goal.

            Lots of growth - Access as a backend only. Not wise to lock into to Access
            forms.
            Speed of getting product to market - Access may be the best option, if
            Jerome is an Access developer
            Application needs to scale - Access as backend, with plans on scaling data
            up later (or MSDE from start)

            There are other items to consider, of course.

            --
            Gregory A. Beamer
            MVP; MCP: +I, SE, SD, DBA

            *************** *************** *************** **
            Think outside the box!
            *************** *************** *************** **
            "Brian" <bcap@IHATESPAM clara.co.uk> wrote in message
            news:1112692760 .95300.1@doris. uk.clara.net...[color=blue]
            > "Jerome" <nospam@nospam. com> wrote in message
            > news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=green]
            >> Hi, I'm a bit confused ... when would I rather write an database
            >> application using MS Access and Visual Basic and when (and why) would I
            >> rather write it using Visual Studio .Net?
            >>
            >> Is it as easy in Visual Studio to create reports and labels as it's in
            >> Access?`
            >>
            >> The advantage of VS.net is that not every user needs Access, right? And
            >> that would eliminate the Access version problem as well I guess.
            >>
            >> I've both done stuff in Access as well as asp.net
            >>
            >> Thanks![/color]
            >
            > Access is a vastly superior development platform for database
            > applications:
            > the cost of development is far lower, and it has wonderful
            > database-centric
            > features like linked subforms and continuous forms. The only reason to
            > use
            > anything other than Access to build a database application is if you want
            > it
            > on the internet, which is something that you just can't do with Access.
            > Even if you have a large user population or demanding security/resilience
            > requirements, it's still best to use Access, linked to a sever database
            > engine such as SQL Server.
            >
            > If you buy the Office Developer Edition, or whatever Microsoft is calling
            > it
            > these days, you can freely distribute a run-time version of Access so that
            > you don't need to buy Access for all your users.
            >
            >[/color]


            Comment

            • Brian

              #7
              Re: Access or Visual Studio?


              "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
              message news:%23ASKbQdO FHA.1392@TK2MSF TNGP10.phx.gbl. ..[color=blue]
              > I would disagree with you on many points.
              >
              > 1. Access is a horrible platform for large databases. While it can get to[/color]
              a[color=blue]
              > rather large size, it is a file based DB, which means perf degrades
              > horribly. I would say 50MB is a good theoretical max, although I have seen
              > Access DBs in the ridiculous range.
              >
              > 2. Access is great for single developers, but bad for team development. It
              > is difficult to impossible to get a team working on the same solution,
              > unless Access is merely a data repository.
              >
              > 3. Access creates monolithic applications, which means there is little
              > flexibility in distributing the work as your company grows.
              >
              > Access certainly fits a niche. It has a wonderful designer and allows you[/color]
              to[color=blue]
              > leverage your work with forms, queries, reports, etc. Much of the work can
              > be done without a huge amount of code. But, you pay a price, as you lock
              > yourself into the Access solution. If you later outgrow, you end up
              > rewriting everything.
              >
              > I am not knocking Access, as it is a great product, but it definitely has
              > its limitations. Whether Jerome should use Access or not depends on his
              > final goal.
              >
              > Lots of growth - Access as a backend only. Not wise to lock into to Access
              > forms.
              > Speed of getting product to market - Access may be the best option, if
              > Jerome is an Access developer
              > Application needs to scale - Access as backend, with plans on scaling data
              > up later (or MSDE from start)
              >
              > There are other items to consider, of course.
              >
              > --
              > Gregory A. Beamer
              > MVP; MCP: +I, SE, SD, DBA
              >
              > *************** *************** *************** **
              > Think outside the box!
              > *************** *************** *************** **[/color]

              1. "it is a file based DB"

              You are talking specifically here about Jet databases. What you say is not
              correct, I have live Access/Jet applications running just fine for years at
              database sizes approaching 1Gb. Not a problem at all, you just need to
              design 'em right. What IS ridiculous is your suggestion of a theoretical
              maximum of 50Mb, and I cannot imagine what you base such a silly claim on.

              Nonetheless, if you do expect to exceed the capabilities of a Jet database
              (which is possible in many ways, not just in terms of size e.g. you may have
              security/resilience requirements which Jet simply can't meet) then (as I
              believe I mentioned) Access makes an excellent client to server database
              engines such as SQL Server or Oracle.

              2. "Access is great for single developers, but bad for team development.
              It
              is difficult to impossible to get a team working on the same solution,
              unless Access is merely a data repository.

              Sorry, you lost me here, it's perfectly straightforward to have different
              people working on different front-end areas and then to integrate them.

              3. "Access creates monolithic applications, which means there is little
              flexibility in distributing the work as your company grows."

              You are going to have to explain that one a bit better. Access as a client
              to a server database engine is every bit as scalable as any two-tier
              client-server architecture using the same database engine. You seem to be
              stuck on Jet again.

              4. "But, you pay a price, as you lock
              yourself into the Access solution. If you later outgrow, you end up
              rewriting everything."

              See above re Access as a client to server database engines.

              5. "I am not knocking Access, as it is a great product, but it definitely
              has
              its limitations. Whether Jerome should use Access or not depends on his
              final goal"

              Jet, whilst an excellent product for the right purpose, certainly does have
              limitations. Access as a client to a server database engine is limited only
              by the server (unless you are big enough to need a three-or-more-tier
              architecture, or you are looking to distribute your app across the internet
              which I already said Access is no good at).

              6. "Not wise to lock into to Access forms."

              How is that any less wise than locking in to, say, dotnet Windows Forms?
              You've got to build your clients in something, and, as soon as you make that
              decision, hey presto, you are locked in.

              7. "Speed of getting product to market"

              What's your point here? All other things being equal, a database
              application will take, quite literally, a fraction of the time to develop in
              Access as compared to Windows Forms in dotnet.













              Comment

              • Brian

                #8
                Re: Access or Visual Studio?


                "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                message news:uZPqlFdOFH A.204@TK2MSFTNG P15.phx.gbl...[color=blue]
                > Access is a monolithic approach. There are many good apps written in[/color]
                Access.[color=blue]
                > But, once you start including forms, queries, etc., it is hard to divorce
                > yourself from Access and move up to another backend database, like SQL
                > Server, as you end up rewriting all of your code.
                >
                > If you opt for an external solution, using Access as the backend only, you
                > can switch to another database without much pain.
                >
                > --
                > Gregory A. Beamer
                > MVP; MCP: +I, SE, SD, DBA
                >[/color]

                See my other reply, that is just so not true.


                Comment

                • Ken Snell [MVP]

                  #9
                  Re: Access or Visual Studio?

                  "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                  message news:%23ASKbQdO FHA.1392@TK2MSF TNGP10.phx.gbl. ..[color=blue]
                  >I would disagree with you on many points.
                  >
                  > 1. Access is a horrible platform for large databases. While it can get to
                  > a rather large size, it is a file based DB, which means perf degrades
                  > horribly. I would say 50MB is a good theoretical max, although I have seen
                  > Access DBs in the ridiculous range.
                  >[/color]

                  Depends upon how you design it. I currently have a client running a split
                  ACCESS database product over a LAN, where the backend file is almost 100MB,
                  with up to 15 concurrent users.
                  --

                  Ken Snell
                  <MS ACCESS MVP>


                  Comment

                  • Arvin Meyer

                    #10
                    Re: Access or Visual Studio?

                    "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                    message news:uZPqlFdOFH A.204@TK2MSFTNG P15.phx.gbl...[color=blue]
                    > Access is a monolithic approach. There are many good apps written in[/color]
                    Access.[color=blue]
                    > But, once you start including forms, queries, etc., it is hard to divorce
                    > yourself from Access and move up to another backend database, like SQL
                    > Server, as you end up rewriting all of your code.
                    >
                    > If you opt for an external solution, using Access as the backend only, you
                    > can switch to another database without much pain.[/color]

                    Not true at all. I have several apps that made the move from Access to
                    SQL-Server with only a few hours of testing. Some of my apps have required
                    no code changes at all, others benefited from using some pass-through
                    queries to stored procedures. Still others were written with adp code and
                    used SQL-Server views and stored procs directly. Larry Linson, one of the
                    Access MVPs has worked almost exclusively on Access front-ends to Server
                    based back-ends. Unless there are a large number of users or a need to use a
                    web app, there is no reason to ever use anything but Access as a front-end.
                    Most database apps are small and never need anything but Access as a
                    back-end either. Anyone who uses anything other than Access to write
                    thick-client front ends is wasting his time and his client's money. I
                    suspect that there are some who may argue with this, but they probably
                    haven't been working for the kind of clients that Access benefits most, nor
                    do they have significant business process experience to go with their coding
                    skills.
                    --
                    Arvin Meyer, MCP, MVP
                    Microsoft Access
                    Free Access downloads:
                    Database Consulting, Business Computer Solutions in Orlando, FL MCP, MVP, Networking, Computers, consulting




                    Comment

                    • Arvin Meyer

                      #11
                      Re: Access or Visual Studio?

                      I've worked with teams of as many as 6 developers building large
                      applications for small numbers of users. With competent project management
                      there were no problems at all. With incompetence, even 2 developers is 2 too
                      many. As far as reuseability goes, I can't speak for others, but most of my
                      code (maybe 75 to 80%) is reuseable.
                      --
                      Arvin Meyer, MCP, MVP
                      Microsoft Access
                      Free Access downloads:
                      Database Consulting, Business Computer Solutions in Orlando, FL MCP, MVP, Networking, Computers, consulting



                      "Cor Ligthert" <notmyfirstname @planet.nl> wrote in message
                      news:ObrnoFdOFH A.1176@TK2MSFTN GP12.phx.gbl...[color=blue]
                      > Brian,
                      >[color=green]
                      > >
                      > > Access is a vastly superior development platform for database
                      > > applications:
                      > > the cost of development is far lower, and it has wonderful
                      > > database-centric
                      > > features like linked subforms and continuous forms. The only reason to
                      > > use
                      > > anything other than Access to build a database application is if you[/color][/color]
                      want[color=blue][color=green]
                      > > it
                      > > on the internet, which is something that you just can't do with Access.
                      > > Even if you have a large user population or demanding[/color][/color]
                      security/resilience[color=blue][color=green]
                      > > requirements, it's still best to use Access, linked to a sever database
                      > > engine such as SQL Server.
                      > >[/color]
                      >
                      > How large is your team to build simultanisly applications with?
                      >
                      > And how you have reusability implemented with that?
                      >
                      > Cor
                      >
                      >[/color]


                      Comment

                      • JiangZemin

                        #12
                        Re: Access or Visual Studio?

                        Hi,

                        I disagree with the idea that once you start developing forms in Access, its
                        difficult to move the backend up to SQL. Depending on how the app is build,
                        its not very difficult at all to upsize an Access application from using JET
                        to SQL.

                        If youre talking about completely moving away from Access front-end
                        development, yeah, then youd have to rewrite a lot of your code. But its
                        the same situation if you were to abandon .NET forms as your front end too.
                        However, one advantage of using .NET approach is you can properly layer your
                        application so that if you do decide to change the front end, it can be a
                        lot easier to handle situations where the front-end changes. Access doesnt
                        easily allow you to structure your projects to promote reuse. But in a
                        smaller, ad-hoc database project its probably fastest to develop.

                        My biggest hassle with Access development involve handling deployments of
                        front-end and Office versioning issues. As far as how easy it is to do
                        reports, look into Sql Reporting Services, it can import existing Access
                        reports. Its pretty easy to use (dont know about labels tho). But theres
                        nothing stopping you from building your database app using .NET, and having
                        an Access db solely for queries/reports/labels.

                        I think anyone who would use Access/JET as backend DB engine for multiuser
                        app in business setting has to be stopped ASAP. I read recently that
                        electronic voting machines used JET, and almost fell out of my chair...

                        HTH,
                        Premier JiangZemin

                        "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                        message news:uZPqlFdOFH A.204@TK2MSFTNG P15.phx.gbl...[color=blue]
                        > Access is a monolithic approach. There are many good apps written in
                        > Access. But, once you start including forms, queries, etc., it is hard to
                        > divorce yourself from Access and move up to another backend database, like
                        > SQL Server, as you end up rewriting all of your code.
                        >
                        > If you opt for an external solution, using Access as the backend only, you
                        > can switch to another database without much pain.
                        >
                        > --
                        > Gregory A. Beamer
                        > MVP; MCP: +I, SE, SD, DBA
                        >
                        > *************** *************** *************** **
                        > Think outside the box!
                        > *************** *************** *************** **
                        > "Jerome" <nospam@nospam. com> wrote in message
                        > news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=green]
                        >> Hi, I'm a bit confused ... when would I rather write an database
                        >> application using MS Access and Visual Basic and when (and why) would I
                        >> rather write it using Visual Studio .Net?
                        >>
                        >> Is it as easy in Visual Studio to create reports and labels as it's in
                        >> Access?`
                        >>
                        >> The advantage of VS.net is that not every user needs Access, right? And
                        >> that would eliminate the Access version problem as well I guess.
                        >>
                        >> I've both done stuff in Access as well as asp.net
                        >>
                        >> Thanks![/color]
                        >
                        >[/color]



                        Comment

                        • Arvin Meyer

                          #13
                          Re: Access or Visual Studio?

                          "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                          message news:%23ASKbQdO FHA.1392@TK2MSF TNGP10.phx.gbl. ..[color=blue]
                          > I would disagree with you on many points.
                          >
                          > 1. Access is a horrible platform for large databases. While it can get to[/color]
                          a[color=blue]
                          > rather large size, it is a file based DB, which means perf degrades
                          > horribly. I would say 50MB is a good theoretical max, although I have seen
                          > Access DBs in the ridiculous range.[/color]

                          I have seen them in the ridiculous range too, and they run fine if well
                          designed. I had a client several years ago that experienced her first
                          corruption of one of the 80 Access 2.0 databases she had hung off a single
                          front end. Once I fixed it she went happily on. Size: 30GB
                          [color=blue]
                          > 2. Access is great for single developers, but bad for team development. It
                          > is difficult to impossible to get a team working on the same solution,
                          > unless Access is merely a data repository.[/color]

                          As I said elsewhere, I've worked with a team of 6. I know of other
                          developers that use Source-safe, but I've never found it necessary.
                          [color=blue]
                          > 3. Access creates monolithic applications, which means there is little
                          > flexibility in distributing the work as your company grows.[/color]

                          I've not had any problems, my databases are distributed by the server. As a
                          user logs on he gets the front-ends he needs.
                          --
                          Arvin Meyer, MCP, MVP
                          Microsoft Access
                          Free Access downloads:
                          Database Consulting, Business Computer Solutions in Orlando, FL MCP, MVP, Networking, Computers, consulting




                          Comment

                          • SusanV

                            #14
                            Re: Access or Visual Studio?

                            You wrote:
                            <q>
                            I think anyone who would use Access/JET as backend DB engine for multiuser
                            app in business setting has to be stopped ASAP. I read recently that
                            electronic voting machines used JET, and almost fell out of my chair...
                            </q>

                            Why?

                            Susan

                            "JiangZemin " <fourpillars@ex ample.com> wrote in message
                            news:uRP$dZeOFH A.3356@TK2MSFTN GP12.phx.gbl...[color=blue]
                            > Hi,
                            >
                            > I disagree with the idea that once you start developing forms in Access,
                            > its
                            > difficult to move the backend up to SQL. Depending on how the app is
                            > build,
                            > its not very difficult at all to upsize an Access application from using
                            > JET
                            > to SQL.
                            >
                            > If youre talking about completely moving away from Access front-end
                            > development, yeah, then youd have to rewrite a lot of your code. But its
                            > the same situation if you were to abandon .NET forms as your front end
                            > too.
                            > However, one advantage of using .NET approach is you can properly layer
                            > your
                            > application so that if you do decide to change the front end, it can be a
                            > lot easier to handle situations where the front-end changes. Access
                            > doesnt
                            > easily allow you to structure your projects to promote reuse. But in a
                            > smaller, ad-hoc database project its probably fastest to develop.
                            >
                            > My biggest hassle with Access development involve handling deployments of
                            > front-end and Office versioning issues. As far as how easy it is to do
                            > reports, look into Sql Reporting Services, it can import existing Access
                            > reports. Its pretty easy to use (dont know about labels tho). But
                            > theres
                            > nothing stopping you from building your database app using .NET, and
                            > having
                            > an Access db solely for queries/reports/labels.
                            >
                            > I think anyone who would use Access/JET as backend DB engine for multiuser
                            > app in business setting has to be stopped ASAP. I read recently that
                            > electronic voting machines used JET, and almost fell out of my chair...
                            >
                            > HTH,
                            > Premier JiangZemin
                            >
                            > "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote
                            > in
                            > message news:uZPqlFdOFH A.204@TK2MSFTNG P15.phx.gbl...[color=green]
                            >> Access is a monolithic approach. There are many good apps written in
                            >> Access. But, once you start including forms, queries, etc., it is hard to
                            >> divorce yourself from Access and move up to another backend database,
                            >> like
                            >> SQL Server, as you end up rewriting all of your code.
                            >>
                            >> If you opt for an external solution, using Access as the backend only,
                            >> you
                            >> can switch to another database without much pain.
                            >>
                            >> --
                            >> Gregory A. Beamer
                            >> MVP; MCP: +I, SE, SD, DBA
                            >>
                            >> *************** *************** *************** **
                            >> Think outside the box!
                            >> *************** *************** *************** **
                            >> "Jerome" <nospam@nospam. com> wrote in message
                            >> news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=darkred]
                            >>> Hi, I'm a bit confused ... when would I rather write an database
                            >>> application using MS Access and Visual Basic and when (and why) would I
                            >>> rather write it using Visual Studio .Net?
                            >>>
                            >>> Is it as easy in Visual Studio to create reports and labels as it's in
                            >>> Access?`
                            >>>
                            >>> The advantage of VS.net is that not every user needs Access, right? And
                            >>> that would eliminate the Access version problem as well I guess.
                            >>>
                            >>> I've both done stuff in Access as well as asp.net
                            >>>
                            >>> Thanks![/color]
                            >>
                            >>[/color]
                            >
                            >
                            >[/color]


                            Comment

                            • Kevin Spencer

                              #15
                              Re: Access or Visual Studio?

                              Here's my recommendation. Everybody who has participated in this thread
                              except for Greg should be using Access,
                              and understand that Access development is not programming. It uses VBA,
                              which is a macro language, not a real programming language, with all the
                              capabilities and complexities that real programming entails. Access has its
                              place - Microsoft Office. It's an office application, for office
                              users/devlopers. It was developed specifically with office users/developers
                              in mind, and is nearly perfect for such users/developers.

                              While Greg's estimation of Access's limitations was somewhat out-of-date (I
                              can remember when 50MB was the limit), he is essentially correct in all that
                              he has said. There are certainly places where an Access database can be used
                              to great efficacy in a LAN or Desktop application. There is no licensing fee
                              for an .mdb file, which can be distributed legally with the app. The Jet
                              engine is fast and clean. but it does have limitations that are based upon
                              the intended use of Access, which is NOT for Internet databases, or
                              databases which require a large concurrent number of users.

                              --
                              HTH,

                              Kevin Spencer
                              Microsoft MVP
                              ..Net Developer
                              What You Seek Is What You Get.

                              "Cowboy (Gregory A. Beamer)" <NoOSpamMgbworl d@comcast.netNo OSpamM> wrote in
                              message news:uZPqlFdOFH A.204@TK2MSFTNG P15.phx.gbl...[color=blue]
                              > Access is a monolithic approach. There are many good apps written in
                              > Access. But, once you start including forms, queries, etc., it is hard to
                              > divorce yourself from Access and move up to another backend database, like
                              > SQL Server, as you end up rewriting all of your code.
                              >
                              > If you opt for an external solution, using Access as the backend only, you
                              > can switch to another database without much pain.
                              >
                              > --
                              > Gregory A. Beamer
                              > MVP; MCP: +I, SE, SD, DBA
                              >
                              > *************** *************** *************** **
                              > Think outside the box!
                              > *************** *************** *************** **
                              > "Jerome" <nospam@nospam. com> wrote in message
                              > news:eyvBB7bOFH A.2532@TK2MSFTN GP09.phx.gbl...[color=green]
                              >> Hi, I'm a bit confused ... when would I rather write an database
                              >> application using MS Access and Visual Basic and when (and why) would I
                              >> rather write it using Visual Studio .Net?
                              >>
                              >> Is it as easy in Visual Studio to create reports and labels as it's in
                              >> Access?`
                              >>
                              >> The advantage of VS.net is that not every user needs Access, right? And
                              >> that would eliminate the Access version problem as well I guess.
                              >>
                              >> I've both done stuff in Access as well as asp.net
                              >>
                              >> Thanks![/color]
                              >
                              >[/color]


                              Comment

                              Working...