Link to home
Start Free TrialLog in
Avatar of Syd2008
Syd2008

asked on

Upsize Access 2003 into SQL 2000 error

I can easily upsize Access db to SQL db by using wizard but at the end I am getting this error which is making me concern.
Can you tell me why I am getting this error
<<Server Error 15135: Object is invalid. Extended properties are not permitted on 'dbo.Table_name.Field_Name', or the object does not exist>>
I am getting this error for all tables and all fields :(
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

is this the real thing in the message { 'dbo.Table_name.Field_Name' }
you might have something in the name of table or field that sql does not like
Avatar of Syd2008
Syd2008

ASKER

I replace my original table name with table_name and field_name BUT its just a simple name no I dont think SQL should have any problem with the name.
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Syd2008

ASKER

I am getting this error message for each fields of all tables
 same error msg with different fields /table names.
<<Server Error 15135: Object is invalid. Extended properties are not permitted on 'dbo.Table_name.Field_Name', or the object does not exist>>
Avatar of Syd2008

ASKER

Thank you for all your help :)