[AccessD] Enterprise Manager replacement ???

As it happens I just did a bunch of work on this. Had to create an Access
app that would let its user run a CD whose Setup copied an ADP to hard disk,
installed a new database, and connected the ADP to said DB. Learned a LOT
about SQL-DMO in a compressed timeframe, no thanks to the MS Help documents,
mind you. Had to google and regoogle numerous times before I discovered
everything I needed. Also got some help from the author of dbaMgr, an EM
replacement written in VB. I don't have an EM replacement because those were
not my requirements, but I'm partway there and intend to finish the job.
I'll add your request to my ToDo list.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: April 10, 2003 12:09 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Enterprise Manager replacement ???

Tom Adams wrote:

>I'm working on a VB6 project with  Sql 7 running on an NT 4 server.
>
>I don't like the limitations of the Enterprise Manager (eg. Won't show 
>the schema or fields when using a Case statement, although it runs 
>fine).
>
>Does anyone know of a replacement product - reasonably priced of course 
>that would work properly with a Case statement.  I've used Tiffany with 
>Sql Server 6.5 and it was wonderful but I think it's about $1,000.
>
>Thanks - Tom