disabling error checking before update database

[John]

Hi,
I have a database model in Visio 10 Enterprise Architect (it comes with
VS.NET 2003).

I have a problem. Many tables have the same columns name. When I do update,
Visio is error checking my model and throws errors like this:
MODEL.VSD : error L2008: 'surface_size_types.mod_user_id' : Column has same
conceptual name as column 'types_of_areas.mod_user_id', but has a different
data type.

How can I disable error checking before database update?

Thanks,
John

 

[John Smith]

You can't I don't think.

Just fix the errors. They are really easy to fix.

You shouldn't have those kinds of errors anyway, if you designed your system
correctly.

Make sure that you leave the "Synchronize While Typing" setting alone,
unless you are going to type in conceptual names manually.

What a pain in the arse!

This is another Interactive Design error - as in poor design.

Come on Microsoft! We love Visio but can't we have flexibility with ease of
use?

 

[MarkB]

Did you ever manage to get around this problem?

I have exactly the same problem, and the types of both columns are identical.

Cheers,
Mark.

 

[sqldebugger]

Actually the error message is misleading.

For some reason visio expects you to name column differently from
parent key column.

I changed name of foreign key column and error is gone.

Also you cannot have multiple references to same parent key from the
same child table.

-peace