Question POS System with MS Access

[latex88]

Hi,

What are the primary reasons why I should not consider using MS Access to build a Point-of-Sales system? I am not too proficient with VBA, but I can get around and I can create the heck out of forms. I understand mySql is much more robust in terms of database, but it is just not that user friendly to me.

My system does require multiple stations, therefore, there may be multiple concurrent users at a given time.

Latex

 

[gemma-the-husky]

no reason not to, i would think

it's as good as any other method.

 

[Lightwave]

If you linked it up to SQL server really there is no reason not to use it other than its a lot of work to create.

However for yourself its probably less work to create it in Access than in another package that you don't know how to create the heck out of forms.

But that's probably more of a reason to use an off the shelf package rather than your own system.

Also you are slightly confusing yourself
MySQL is a backend like
SQL server or
ORACLE

You could if you wanted link Access front end up to a MySql backend. And presumably if you used MySQL without access you'd need to use something else to design the front end. Thus MySQL is not a direct replacement for Access.

In fact Access will link to any of the above...

Have a look at this
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-examples-tools-with-access.html

searching the internet for "link access to SqlServer" or "Oracle" will find very similar articles.

 

[sakshisyan]

no reason not to, i would think

it's as good as any other method.

Hmm agree!! :banghead: