Upsizing Problems using access 2000 to sql

[AustralianAccommodation.com Pty. Ltd.]

I am trying to upsize some of my tables that are full of data upsized fine
according to the upsize report whilst other tables with little data did not

table one table as an example Properties Categories it has  2 fields in it
an id field that is the primary key and a category field

the id field is auto number (and yes I have converted it to just number and
still not go same error) and the category field is simply a text field

in the upsize report it says table was skipped or upsize failed

in comparison I then have a guest comments table with around 15 fields that
has around 40 records in the table its id field is set to auto number there
is a data/time field as well along with plenty of differ text fields in the
upsize report this table "guest comment" upsized perfectly.

your words  of wisdom would be appreciated

also does anyone know a url link where I can download enterprise manager. As
I do not have a copy of sql server I was wanting to admin the sql database
via the access 2000 front end without having to buy sql and also learn a new
database package


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.