I'm currently working on my first Access Project using Access 2000.
(I've done a fair amount with Access before, but not Access Projects).

I seem to have connected to the SQL Server database fine (it's on a
remote web site). However, when I try to use "Design" or "New" to
create a Table, the Table window opens up (empty) for a split second
then immediately closes. I don't get any error message.

If I try to use "Design" or "New" to create a View, the windows stays
open. However, there are no Tables to create the View on...

If I open up another database on the same server (using the same
username and password) I can open those Tables, but still can't
"Design" them.

Any idea what's wrong?

Thanks,

SB