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 :(
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
I am getting this error for all tables and all fields :(
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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>>
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
ASKER
Thank you for all your help :)
you might have something in the name of table or field that sql does not like