Re: MS Office Update to Access 2003 killing me?

i_j_hutch wrote:
Hi all--

Not sure if this is the right ng, but here goes...

Previous to applying a recent patch to MS Office Access 2003, I was
able to execute the following SQL query which would change a field in
the table from a Yes/No to a Long integer:
ALTER TABLE <TableName> ALTER <FieldName> Long
This would automatically change the data values in the table from
checkboxes to 0's and -1's.

But now (since applying this patch), the type is changed to Long in
the Design View, but when looking at the table in the Data*** View,
the data still shows up as checkboxes!

<snip>
...but the problem is that this puts the field at the end of table
(due to other reasons, the order IS important)

Using a third-party app that uses selstar? Uggh. My sympathies.

instead of the middle
where I need it.

So MVPs and Microsoft folks, can you confirm that this is now a
problem with Access in the latest patch? If so, will it be fixed
anytime "soon"?


I rarely deal with Jet databases. You should post to an Access group if
nobody replies here.



--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.