Can I use MSDE in a Microsoft's Corporate Client

I Work in a Corporation where SQL is not an standard to deploy but office 2000 are desktop utilities by default. They use access, word, excell, etc to work. Can I use MSDE with Vb 6 and how can I administer the MSDE database ? I have seen Access frontend
to make changes and permisions and its very poor. Can I use Sql Server Console or Third parts ?
Thanks
hi,
"Designer improving costs" <janou_dank@.yahoo.com.ar> ha scritto nel
messaggio news:F799D60E-DC43-480E-BE57-6EC9E7C02B47@.microsoft.com...
> I Work in a Corporation where SQL is not an standard to deploy but office
2000 are desktop utilities
>by default. They use access, word, excell, etc to work. Can I use MSDE with
Vb 6 and how can I
>administer the MSDE database ? I have seen Access frontend to make changes
and permisions and
>its very poor. Can I use Sql Server Console or Third parts ?
> Thanks
you can download and install MSDE for sure in corporate environments, as
MSDE release A (http://www.microsoft.com/sql/msde/do...s/download.asp) is
free..
as regard management, you can use SQL Server management tools like
Enterprise Manager and Query Analyzer only if you a licensed owner of a full
SQL Server edition, but you can write your own tool, use Acces and/or resort
to third parties tools like those provided at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If you have licensed SQL Server ownership with which the tools are
available, you can use the tools to manage the MSDE installations.