Change Field Formats Programmatically

[Frank]

Hi,

I'm trying to figure out how to programmatically change a date/time
field's format to medium from a stand alone EXE.

Basically I have many MDB's in a folder each with multiple tables each
of which have multiple date/time fields. I want to create an EXE
(maybe in c#\vb.net\vb6) that can get all the mdb file --> read all
the tables --> read all the fields and update the field format to
medium for those that are date\time fields.

I can find a lot of VBA code for access, but not for what I need to do
and VBA is not really what I need. I did have (can't find right now)
some VBScript that would do this for a single MDB but it would open
the MDB in Access before it did the update.

Any suggestions would help, not really sure what my options are.

Frank

 

[Douglas J. Steele]

If you've got VBA code, it should work fine in VB6.