-
Feb 5th, 2014, 09:58 AM
#1
Thread Starter
Fanatic Member
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
-
Feb 5th, 2014, 10:42 AM
#2
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
-
Feb 5th, 2014, 11:27 AM
#3
Thread Starter
Fanatic Member
Re: VB with ACcess or Sql Server
Hi Zvoni
User will not be more than 3-4.
Thanks
-
Feb 5th, 2014, 11:29 AM
#4
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
-
Feb 5th, 2014, 03:36 PM
#5
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.
-
Feb 7th, 2014, 12:44 PM
#6
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|