How to change Access DB field type, DAO

I use VB6 with access97 DAO and I cannot change a field type in code. Is there a way of doing it ?
I want to change a field from dbLong to dbSingle. I would prefer not to lose data, but if I have to, I have to.

I had to do that once. All I did was create a new table, then copy the data from the old table to the new (converting on the way), then delete the old table and rename the new.

"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder