Upsizing Wizard.

[Jay Bukstein]

When upsizing an access database to SQL 2000 the Yes/No
column moves to a Bit type field, But micorsoft has a
problem with this.

The forms that try to update data in a Table/Query with
the upsizied Bit fields causes a Write Confict error.
Any ideas on what type I should make those fields or is
there a fix available for this proble in Access 2002?

 

[Tim Ferguson]

When upsizing an access database to SQL 2000 the Yes/No
column moves to a Bit type field, But micorsoft has a
problem with this.

They should be exactly the same, and I never had any problem moving a
Boolean field (admittedly, to MSDE 1, which is the same as SQL Server 7).
More details please on exactly what causes the error.

As an afterthought, you might get more help in the m.p.a.adpsqlserver
newsgroup.

B Wishes


Tim F