Hi Alan,
The most important thing to mention here is this: MSDE is the same as MS SQL Server, but it is downloadable for free! To be honest, there is still a difference: MSDE comes without all the administration apps like Enterprise Manager. But with blueshell Data Guy you can administrate your MSDE as well!
If you want to connect to a database in a client server DBMS like MS SQL Server/MSDE you have to use File→New→OLE DB Connection. The File→Open only opens file databases like *.mdb etc. that are supported by Jet.
Act like this:
► Start blueshell Data Guy
► Select File→New→OLE DB Connection, the Data Link Properties dialog appears.
► Select "Microsoft OLE DB Provider for SQL Server" and press Next.
► Enter the info for your connection and press Test Connection.
► When tested successfully, finally press OK.
► The connection is opened and you can now browse and edit your tables, launch SQL statements and more...
If you have any further question, please don’t hesitate to contact me again.
Best regards,
Harry