Upgrade error from V7.5 Multiuser

[Jim Riley]

Hmmm

Getting the following error message when I try to upgrade

"Failed to run SQL statement

ALTER TABLE [Product] ALTER COLUMN [Product Reference] TEXT(30)

when upgrading - fatal error.
Reported error was:

Cannot change field 'Product Reference'. It is part of one or more relationships."

Anyone come across this before

We havent changed the underlying database in 7.5

Jim

[Jim Riley]

Anyone got any ideas?

[Jan]

Hello Jim,

Do you have any forms or table settings in the database that use the product reference field. Actinic trying to drop the field so that it can be recreated as a slightly larger field internally to cope with duplicate product references but it can't because something is relying on it.

I've never seen this before, it's a bit weird.

Regards,