>>>Any tool to design the Database and Tables for the MSDE
>>>(Microsoft Data Engine)? If only the MSDE is installed
>>>on a PC, which tool can I use to help me design the
>>>Database and Tables visually, like MS Access interface
>>>or the MS SQL Server interface. Thanks.
>>
>>You can use Enterprise Manager (from SQL Server 7.0) or Access 2000.
>>
>>You can also use the Data View from VB (but you won't be able to create database).
>>
>>You can also use VisData (the example that comes with VB) but I think that you won't be able to create database).
>
>If I were to use MS SQL Server Enterprice Manager, is it that first of
>all I need to install the SQL Server(Complete installation)?
>So once I have created the Databases/Tables, then I will uninstall the
>SQL Server from the PC(because there isn't any software licence)?
>
>I only install the MSDE(as it is free), I don't know how to use the
>SQL Server with the MSDE(although they are actually the same).
>Do I install SQL Server, creat the Tables, and then uninstall SQL Server
>leaving the Database in the PC(I think it will also be removed)?
You normally use Enterprise Manager from another computer. Enterprise Manager on one PC can see all databases on the network!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com