Hi Charles.

>uniqueidentifier is not an option on the dropdown. I thought I might get it on there by fiddling the typemap table to make uniqueidentifier one of the choices for character (in place of text)
>but when I rebuild the app I get an operator/operand type mismatch ( which it is technically as only a very specific string would be seen by SQL as a uniqueidentifier.

I looked into this. It's a goofy error caused by the TYPEMAP table already being open (likely because you added the uniqueidentifier record to it). I've fixed that but in the meantime, you should be able to CLOSE DATA ALL before running the Upsizing Wizard and it should work.

A couple of other things:

- I added several missing data types: uniqueidentifier, ntext, nchar, nvarchar, etc.
- There's a weird versioning thing in the TYPEMAP table and associated code. I've taken care of that too, but in the meantime, you probably have to put "SQL Server4x" into the SERVER column of the new record in TYPEMAP.

Doug