MS Access field type

[dakota97]

Hi all,

Is it possible to programatically change the field type in an Access DB? The reason Im asking is because I found a bug in my program that incorrectly calculates the tax for a sale if the tax rate is in the form of 6.5% or 8.25%. If the tax rate is 6% or 8%, it works fine.

I need to put out an update for people who have downloaded my program that will update the field type in the database without losing the existing data.

Any suggestions would be greatly appreciated.

Thanks in advance,

Chris

 

[HJB417]

u will have to use the ALTER TABLE sql command.