Can I use Access Instead of SQL Server?

Question

I want to build an Application Using VB.Net, so i need sw to Build the DB , Can i Use Access Instead of SQL ? and what's the difference between those Both, Adv & Disadv.. Please Replay Quickly , Thnx Alot My friends.

Answer 1

You can use Access instead of SQL Server. You may have to recode later because Access has a really goofy dialect of SQL. Also, SQL Server is a real DB server and Access is a toy which _frequently_ fails in multi-user scenarios. I have watched it lock up repeatedly on a bunch of programmers who are trying to use it for lab equipment checkout.



Or you can put together the application with something like PostgreSQL and Django using the very flexible Python language, or even do it .NET style using Cobra. All CIL assemblies are created equal (except those from Iron Python), so you might as well use the free software stuff which will run on both .NET and mono, so that it covers the majority of server platforms.

Answer 2

Access is easier for some people to build the front end, but you are taking away that advantage by developing in VB.NET. So, I can't think of any advantage to using Access.



SQL Server is more scalable, you start running into Access problems early in multi-user applications. Security can be set at a more granular level. It is free if you use SQL Server Express. If your database needs exceed the capabilities of SQL Server Express, then Access isn't going to help you out anyway.

Answer 3

Both work the same way, the only difference is... scalability and security, yah right, the larger the amount of data and users connected to it the slower it gets (Access DB), while in sql, there are no limitations, except the price of the DB system.



In security issues, Access is very vulnerable unlike sql, accounts and users will be needed to register on the server 1st before you could connect to it or access the DB.

Answer 4

Yes you could use access, but i really wouldn't recommend it. Access is not a good DB except for basic functions. You can get access to do alot of things, but it is alot of work, and really not worth the time. SQL is much better database, and I would recommend using it instead