Unanswered: Error -2147217900 (or 80040E14 in Hex)
Hi all, this is my first post here.
I'm trying to execute the following sentence:
ALTER TABLE LIBRE2 ALTER COLUMN DAT001 varchar(5)
getting the following error:
Error in ALTER TABLE ALTER COLUMN DAT001. PRIMARY KEY CONSTRAINT aaaaaLIBRE2_PK has access to this column.
I'm using Visual Basic 5.0 over an SQLServer 7.0 database.
It seems to be an error with the index of the table, but I need to make this change inorder to solver other problems I have, and I need to do this operation by code, not with de tools of the SQL Server. Does anyone knows any workaround to solve this problem?
After analyzing the problem I reached the same solution, so I make the process just to make a few changes before altering the table. Not only remove the constraint, but also check if the field was a primary key or foreign key, but it just give me a new implementation problem, but I'm solving it. After the holidays I think I'll solve it all.