DTS Import from Access 2000 to SQL Server 7 says success but no tables?

Hi All,
I am trying to import all tables from an Access 2000 database into a
SQL Server 7.0 database. The import seems to work fine and says it was
successfull, but the tables are not listed under the Tables node. If
you look at the permissions for the Public database role, the tables
are listed there.
Can anyone tell me what the problem is?
Thank You Very Much For Your Time,
Nathan
I should have included that I am runnig this from the DTS Import Wizard
in Enterprise Manager.
|||You will have to refresh the tree view to see the new objects.
Andrew J. Kelly SQL MVP
"Nate" <nathandeneau@.braintrade.biz> wrote in message
news:1135025968.611334.163700@.g44g2000cwa.googlegr oups.com...
> Hi All,
>
> I am trying to import all tables from an Access 2000 database into a
> SQL Server 7.0 database. The import seems to work fine and says it was
> successfull, but the tables are not listed under the Tables node. If
> you look at the permissions for the Public database role, the tables
> are listed there.
>
> Can anyone tell me what the problem is?
>
> Thank You Very Much For Your Time,
>
> Nathan
>
|||Andrew,
Thanks for the reply.
I was able to view the tables only after closing out of Enterprise
Manager completely. I tried collapsing and refreshing several nodes,
including the database node, the DatabaseS node, the server node, and
the "whole darn node (--:", and only when I completely closed-out of
Enterprise Manager and reopened the program, did it refresh?
-N
|||Are you running the latest service pack for 7.0? You might want to consider
upgrading at some point.
Andrew J. Kelly SQL MVP
"Nate" <nathandeneau@.braintrade.biz> wrote in message
news:1135028941.792066.217000@.g49g2000cwa.googlegr oups.com...
> Andrew,
> Thanks for the reply.
> I was able to view the tables only after closing out of Enterprise
> Manager completely. I tried collapsing and refreshing several nodes,
> including the database node, the DatabaseS node, the server node, and
> the "whole darn node (--:", and only when I completely closed-out of
> Enterprise Manager and reopened the program, did it refresh?
> -N
>