Cannot create or modify table in MSDE from Access

[Sander Verhagen]

Hi,


I've just today installed MSDE. I am able to connect to my database using
osql.exe and work with it from the command-line. I've added some tables that
way, and some records in them too.

Now I've linked it to an Access project (adp), and see the tables I've
created, with my records in them, and I am able to add some records.
I am, however, not able to do any database design, whether it is something
new or a design modification, for tables and e.g. stored procs.

When I click New (for a table), it'll briefly outline the design window and
then it vanishes again.

I've tried this linking as both 'sa', or through NT authentication, with the
same result.

Could you get me on the right track for this? Thanks already!


Sander Verhagen
[ (e-mail address removed) ]

 

[Mario]

My undestanding of MSDE is that it works the way you just
mentioned. The interfaces to designing anything will be
if you have a version of SQLServer running on your
machine, OR have the SQLServer tools from SQLServer
installation installed on your machine. Otherwise you need
to to everything with SQLSyntax using the connection.

The MSDE concept is used for delivery, this is like a run-
time version of sort. It is the same engine as SQLServer
but without end-user interfaces for designing.

I hope I am right on this!