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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Frank" <(E-Mail Removed)> wrote in message
news:edb42810-166d-476a-944e-(E-Mail Removed)...
> 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