How can I read the data type of a field in an MS Access database

I need to be able to determine if a field in an Access database is of a certain data type, and if it isn't, to change it to what it should be.

I can't seem to find any way of reading the data type of any field in any table - can anyone give me a metod of getting this info?

Thanks

..Bob

This topic has been closed for replies.

Inspiring

Does <cfdbinfo> work for Access DBs?

You might be better off asking this on a MS Access forum. It's more of an Access issue than a CF one.

--

Adam

Sign up