MS Access for business.

[saffyre]

The company I work for want to setup an access database to manage their orders and they need to purchase the necessary software. They have asked me to have a look but im not sure about licensing for business use. They have various office versions on their pc's and theres only about 4 of them using pc's. Would I need to buy a whole suite of office apps or can I just purchase access. What about licensing? Would a professional edition of the software cover it or would I need to buy a copy for each pc etc?

cheers

saFFyre

 

[Fr0dders]

access comes under the office suite of applications

It can be bought individually of Office for about £180. But considering office 2003 proffesional is about £300 its more effective to get office professional edition that includes word / acess / outlook / excel / powerpoint etc.. Whether you buy Access on its own, or go for the office suite, or go for 2003 / 2007 depends on your budget and what you've got already. But you need 1 license per user using it.

personally, id be taking the oppertunity to do so some in house programming. Write a webpage to do it. You programme the web page in ASP.net and store the information in a SQL database. A customer order system is one of the classical examples in most asp.net / SQL books. Ive got books on both on my desk now.

You could write the entire system yourself. And crucially, because the web application runs off 1 server, you dont have to worry about licensing as the client access the application through IE / firefox.

If you want more information as to whats possible and what books to be looking at drop me an e-mail at the address in my profile