SQL vs Access for BackEnd

[Nimrod]

Hello Access Experts !

I do a fair amount of coding in excel. However I'm fairly new with Access and even less so with SQL.

I'm interested in doing a project in which I would like to use excel as my front end and either Access or SQL as my Back End . And I'm just wondering how robust Access will be for me. I'm going to want up to 12 users accessing the DB thru excel at any one time. Am I going to have locking issues with Access ?

Thx for your time :D :D

 

[WonLee]

For a system with 12 concurrent users, Access might not be your best choice.
MS markets Access as a desktop db. DB being loosely used.

I'm not sure if Access 2002 has row locking, but I don't think 98 or 2000 had those features.

I, personally, really enjoy working in Access. It's easy and it's quick.
I'm trying to develop some VB skills to really take advantage of it.
However, you might want to consider mySQL, Oracle, or MS SQL Server.

I don't think anyone could go wrong with either one of the three. Although Oracle or MS SQL might not be worth the price for 12 users.

My experience has been that mySQL is best when performing a lot of SELECT queries. Oracle shines when running a lot of SP. MS SQL is somewhere in between the two, but easiest to install, use, and maintain.
MS SQL, also locks you into the MS universe.