Thanks for the answer, but it doesn't help too much....
I do not have time to begin recreating the catalog while there is a wizard
in the product , I just want to know why the wizard doesn't give me any
error, it just hangs MsAccess!!!! I have try it in other installations but
it is the same, I have read the white papers of msdn looking if there was
any incompatibility of field types but it sayd that the wizard transform
them!!!
I am thinking about do a wizard my sef using ADO to read the database
catalog and create it in the sqlserver conection:
table by table,
field by field,
index by index
and at last relation by relation.
the same with the querys reading the text of each one and storing it if it
is a view.
if you have more advice it will be very wellcomed ;-)
Luis
Quote:> The "wizard" only works if I do not select to convert indexes and
relations,
> it only works if I just convert just the fields of the tables .
> could you please answer me how to make the wizard to work? Please, it is
> very urgent...
You will have to recreate the indexes and relationships manually :-( The
bright side of this is that doing that, you'll get a chance to normalize
your database. Perhaps you'll find that of your 100 tables, only 20 or so
are really needed.
The upsizing wizard was improved in Access 2002, but I still doubt that it
would convert a database with 100 tables without a problem.
Vadim
by