Visual Studio Tools for the Microsoft Office System?

  • Thread starter Thread starter Zlatko Matiæ
  • Start date Start date
Z

Zlatko Matiæ

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

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.)
 
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
 
Hello.

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

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

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) ?
Click to expand...

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?
Click to expand...

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.)
 
Hi, Zlatko.
Did I understood you correctly: MSDE is included in MS Access 2003 (Access
itself without rest of Office) ?
Click to expand...

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.)
 
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.)
Click to expand...
 
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
 
Back
Top