Connection ACCESS 2007 with SQL Performance

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • wassimdaccache
    New Member
    • Apr 2007
    • 222
    #1

    Connection ACCESS 2007 with SQL Performance

    Dear Experts,

    I got an opportunity to implement a project for a market. I have been reading the proposal for this market it seems it is a huge application whereby we will have 6 cashiers 2 accounters 2 stock keepers...

    Is access 2007 able to handle such application?

    if I want to share an access application for more than 10 computers am I going to face some performance problems !!!?

    Connecting access forms to SQL server will be a good point for the performance and huge data storage ??

    Does (VB 6.0 and SQL) provide me better performance then (ACCESS SQL)??

    Actually I am affraid to signe the contract since it is my first time that I do a big application... I need to know your opinion my friends


    Appreciate you all in advance



    Thank you
    Tags: None
    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387
      #2
      If your backend data is in SQL Server then you can have multiple copies of the frontend in Access. Technically you can have up to something like 250 users in an access application. I've never tried anything that big. Multiple users is not a problem. Still I would advise giving each user there own copy of the frontend rather that having them all access the same copy. You avoid potential corruption problems of the database from things like server timeouts/crashes.

        Comment

        • wassimdaccache
          New Member
          • Apr 2007
          • 222
          #3
          Thank you for your reply

          Actually this is what i am willing to do.

          I wonder if it is better to go into VB 6.0. "unfortunat ely i don't know vb.net and other platform "

          Does VB 6.0 able to provide me a better performance then access 2007 ?

          Is there any converter that convert VBA into VB 6.0?

          Thank you for advising me

          Regards

            Comment

            • MMcCarthy
              Recognized Expert MVP
              • Aug 2006
              • 14387
              #4
              You'll have to ask the experts in the Visual Basic forum about VB 6 as I'm afraid I don't really use it.

                Comment

                • NeoPa
                  Recognized Expert Moderator MVP
                  • Oct 2006
                  • 32656
                  #5
                  I wouldn't advise going into such a project and burdening yourself with anything you don't need to. Use what you're familiar with and you know works.

                  If that is Access, then all well and good. If you go into VB then a number of items you're used to having available are likely to be missing and maybe you'll need to create for yourself. If you want to do that then all well and good, but I'd certainly recommend you play with that in your own time first. Not at the start of an important project. Think safety nets ;)

                    Comment

                    • NeoPa
                      Recognized Expert Moderator MVP
                      • Oct 2006
                      • 32656
                      #6
                      For any interested parties, a new (hijack) question was posted in here which has now been moved to its own thread (Recategorise Date Results).

                        Comment

                        Previous template Next
                        Working...