F
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
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