Visual Studio Tools for the Microsoft Office System?

Z

Zlatko Matiæ

Can anybody explain me whether MSDE is or is not included in Visual studio
tools for Office ?
 
6

'69 Camaro

Hi, Zlatko.
Can anybody explain me whether MSDE is or is not included in Visual studio
tools for Office ?

The MSDE is not included in VSTO, because VSTO includes the SQL Server 2000
Developer Edition. The MSDE is included with Microsoft Office 2003
Professional and Microsoft Office Access 2003, either of which is required
to use the Access Developer Extensions from VSTO.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Z

Zlatko

OK.
What is the difference between MSDE and SQL Server Developer Edition ?
Is it possible to use SQL Server Developer Edition (from Visual Studio Tools
for Office), instead MSDE, for Access Projects (.adp) ?
What do you think about such combination?

Thank you,

Zlatko
 
Z

Zlatko

Hello.

Did I understood you correctly: MSDE is included in MS Access 2003 (Access
itself without rest of Office) ?

Zlatko
 
6

'69 Camaro

Hi, Zlatko.
What is the difference between MSDE and SQL Server Developer Edition ?

MSDE is a version of SQL Server 2000, but with reduced functionality. It
allows one to create a Microsoft Access ADP database and store up to 2 GB of
data, lacks the Enterprise Manager available in SQL Server, and allows up to
five threads for optimized connections (additonal threads will be slow).
The MSDE can be used only if one has a license for Microsoft Access 2000 or
newer, or Visual Studio 6 or newer.

SQL Server Developer Edition is the version of SQL Server 2000 for building
databases in a development environment. It cannot be used in a production
environment.
Is it possible to use SQL Server Developer Edition (from Visual Studio Tools
for Office), instead MSDE, for Access Projects (.adp) ?

One may develop databases using this combination, but one cannot deploy
these databases in a production environment. The SQL Server Developer
Edition is not licensed for that.
What do you think about such combination?

It's not legal for production environments. Use SQL Server 2000, MSDE, or
SQL Server 2005 Express Edition, instead. This last is a Beta 2 version, so
beware of using it in a production environment.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
6

'69 Camaro

Hi, Zlatko.
Did I understood you correctly: MSDE is included in MS Access 2003 (Access
itself without rest of Office) ?

Yes. MSDE comes with MS Access 2003 or MS Office 2003 Professional
editions. It may also come with the Small Business Edition (which includes
the Access runtime), but I'm not positive. I tend to think not.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Z

Zlatko Matiæ

Thank you for very helpfull information!

Zlatko

'69 Camaro said:
Hi, Zlatko.


MSDE is a version of SQL Server 2000, but with reduced functionality. It
allows one to create a Microsoft Access ADP database and store up to 2 GB
of
data, lacks the Enterprise Manager available in SQL Server, and allows up
to
five threads for optimized connections (additonal threads will be slow).
The MSDE can be used only if one has a license for Microsoft Access 2000
or
newer, or Visual Studio 6 or newer.

SQL Server Developer Edition is the version of SQL Server 2000 for
building
databases in a development environment. It cannot be used in a production
environment.


One may develop databases using this combination, but one cannot deploy
these databases in a production environment. The SQL Server Developer
Edition is not licensed for that.


It's not legal for production environments. Use SQL Server 2000, MSDE, or
SQL Server 2005 Express Edition, instead. This last is a Beta 2 version,
so
beware of using it in a production environment.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Z

Zlatko Matiæ

Hello, Gunny!

Just to summarize: Can I legally package and deploy ADP solutions (Access
Project aplications) if I buy the following combination: MS Access 2003 +
Visual Studio Tools for Office System ?
Namely, I called local Microsoft center and the guy responsible for
informations couldn't answer me exactly...
Is it neccessary to buy complete MS Office or I can buy only Access 2003 in
order to be able to use Packaging and Deploying wizard from Visual Studio
Tools for Office? Access runtime etc. ?

Thanks.

Zlatko
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top