>>Although I haven't tried it, I seem to remember that the Server Enterprise Manager (SEM) can connect to MSDE.
>
>I'll try and find it.
>
>>All database objects (tables, stored procedures, etc) can be created by submitting commands to MSDE.
>
>Submitting commands? With SQLPT, or is there another method?
>
>Thanks!

Option 1

OK... the best thing to do is get the SQL 7.0 client tools. Unfortunatly they don't come with MSDE... The idea being that the devloper would set up the database with the SQL 7.0 tools and deploy it with MSDE.

SO... option 1... Install SQL 7.0 Client tools on your PC.

Option 2

If you have Visual Studio standard, you have VB... There is a sample ap that comes with VB, called, er... VISDATA.EXE that allows you to connect to an ODBC data source and I think it allows you to modify tables also.

Option 3

Use a database CASE tool like xCase, ERWin, Data Archetech to design your database. All these tools will generate a script that will create the database, tables, etc. All you have to do is submit the script with SPT ... Although I don't know how long of a string you can send with VFP SPT.

Option 4

Create the database in VFP and use the SQL Upsizing wizard to move it to MSDE.


Option 5

Create SQL statements and send the to the backend... YECH! Actually, I think using Access here might be easier than VFP.


Good luck to ya.

BOb