Results 1 to 6 of 6

Thread: VB with ACcess or Sql Server

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Posts
    688

    VB with ACcess or Sql Server

    Hi

    I have client/server application . Please tell me will there be any difference on performance like speed etc if i use MS-Access instead of Sql Server . Network connectivity can be through Ethernet or Fibre Optical Cable.

    Thanks

  2. #2
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,415

    Re: VB with ACcess or Sql Server

    You mean beside the connection limit of 64 users per process and 256 users in total?
    if you have more than 10 users at the same time i'd recommend using sql server
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Posts
    688

    Re: VB with ACcess or Sql Server

    Hi Zvoni

    User will not be more than 3-4.

    Thanks

  4. #4
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,415

    Re: VB with ACcess or Sql Server

    Then there shouldn't be any issue regarding speed
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  5. #5
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,143

    Re: VB with ACcess or Sql Server

    I am by no means an expert on this subject (nor even a novice), however, this LINK might provide some good advice for you.

  6. #6
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: VB with ACcess or Sql Server

    How about storage? How large do you see this database getting? How many records do you envision there being in this database in the next 6 months? In the next 12 months? In the next 18 months?

    If your record count will be climbing into the 6 or 7 digit figure range I would go with SQL Server. (Actually, based on nothing more than "just because" I would go with SQL Server or at least SQL Server Lite over Access)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width