I'm losing hair faster than I can count on this problem so if someone can
help me I'd really appreciate it.
I'm using vb3.0 (with compatibility layer installed) for this project. I
need to change the fieldsize of a text field in an access 2.0 database.
I've RTFM'ed till I'm blue in the face. It says I can do this if the
database is closed. How do I access the Fields object if the database is
closed? I've played with code for 3 hours now and no luck. How can I do
this without making a scratch field and copying all the values to it, then
deleting the original field. then recreating it (with a new size) and
copying all the values back then deleteing the scratch field? Their has got
to be another way.
Lone Star Business Systems