Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Upsizing wizard error

28 views
Skip to first unread message

bobh

unread,
Nov 13, 2012, 2:56:30 PM11/13/12
to
Hi All,

I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the table
to SQLServer and when it's finished uploading the records it start
displaying the same error for each field in the table; the error
message is


EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.


I have no idea where this is coming from, in the upsizing wizard there
is no option to set 'extended properties. I don't even know what is
meant by 'extended properties'.
what is it, where is it set and how do I turn it off??
thanks
bobh.

Patrick Finucane

unread,
Nov 13, 2012, 8:08:25 PM11/13/12
to
I've never seen the error. My suggestion is to start deleting columns and then try to upsize again. Sooner or later the column causing errors will be exposed.
0 new messages