Very Computer

by **dere** » Tue, 02 Apr 2002 21:06:22

Hi

Help. I have produced a database for use in the building construction
industry. The current database is in access 2002. I now need to develop it
into a saleable product. Do I purchase Microsoft access developers Toolkit
Or would I be better lashing out on sequel server. If I buy SQL (800.00)
can I use it to develop my current access database into a fully developed
programme or do I need new skills when I convert.

what would you do?.

--
Regards

Derek

by **Shan** » Tue, 02 Apr 2002 23:40:33

Derek,

First of all, if you are developing your front end application with a
product such as VB or C++, you do not need to purchase MS Access Developer
Edition. An MDB can be distributed without licensing. However, if the
entire application is done using MS Access, then you will need to either
purchase Access Developer, or alternatively bundle Access with you
application. Based on my experience I would choose the latter in this
situation.

Secondly, SQL Server is fairly straight forward when it comes to basic
functionality such as maintaining tables. However, the cost of your product
to the customer will be quite a bit higher. I would make your decision
based on the power that your application needs, and the number of records
and users that will be processed.

Best of Luck!

Quote:> Hi

> Help. I have produced a database for use in the building construction
> industry. The current database is in access 2002. I now need to develop
it
> into a saleable product. Do I purchase Microsoft access developers
Toolkit
> Or would I be better lashing out on sequel server. If I buy SQL (800.00)
> can I use it to develop my current access database into a fully developed
> programme or do I need new skills when I convert.

> what would you do?.

> --
> Regards

> Derek

by **Wm. G. Urquhar** » Thu, 04 Apr 2002 16:26:23

> Hi

> Help. I have produced a database for use in the building construction
> industry. The current database is in access 2002. I now need to develop it
> into a saleable product. Do I purchase Microsoft access developers Toolkit
> Or would I be better lashing out on sequel server. If I buy SQL (800.00)
> can I use it to develop my current access database into a fully developed
> programme or do I need new skills when I convert.

> what would you do?.

> --
> Regards

> Derek

Hi Derek,

You may want to consider using the MSDE for this project. The MSDE or
Microsoft Data Engine, is what you could really describe as a Junior SQL
Server. There are licencing issues but from what you say it appears that
you will be covered by this.

I use it all the time, and have had no problems with it.

Use this
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/ac...

as your first point of reference.

HTH.

-Regards,

William.