conversion issue..datatypes

D

De Veloper

I recently converted a database from '97 to 2003.

When I import a table from the '97 version, the fields I had as currency
are defaulting to binary fields . I changed them back to currency, yet when I
run a marcro using the table for updates, the fields change back to binary
populating the data as gabage results.

What to Do?
 
J

John Vinson

I recently converted a database from '97 to 2003.

When I import a table from the '97 version, the fields I had as currency
are defaulting to binary fields . I changed them back to currency, yet when I
run a marcro using the table for updates, the fields change back to binary
populating the data as gabage results.

What to Do?
Click to expand...

Sheesh... I've never seen THIS happen, and I've upgraded several
databases!

Try creating the new table, design mode only, with a Currency
datatype. Link to the existing 97 table, and run an Append query. Does
that get around the problem?

Also doublecheck the datatype in the A97 table... this sounds fishy!

John W. Vinson[MVP]
 
G

Gerry b

I'm getting the same problem, except the datatype text is defaulting to binary.
This is sure upsetting the many many make table queries we use to append data.

Did you ever find an answer?
Thanx in advance,
Gerry b.
 
D

De Veloper

I just made the field a text field and placed a default value ($0.00) in is.
When I run the Update query , the field is populated (replaced) with currency
data as text. I just need the figure for reference, I'm not calculating once
the update is complete. I suppose if I were, I would have to then use the
function to convert from text to currency before any calcuation could be
performed.
 
Top