Alter field type using VBA or similar

[Neil]

I need to change the data type on a BE set of tables that I no longer have
access to directly.

The table in the backend contains an unused field currently set as a
currency field - I now need to change this to a text field.

Can I do this using VBA, or something similar or do I need to get the BE
sent to me (which I@d rather not do?)

Thanks in advance.

Neil

 

[Alex Dybenko]

Hi,
you can do this in few steps, just make a proc and ask to run it once:
create a new text field in your table (createField method)
if necessary - copy data from old field to new one using update query
delete old field fields.Delete
rename new field to old one fields("oldname").Name ="newname"


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com