Create an access MDB programmatically

[SimonTheSponge]

Does anybody know if this is possible at all using ADO ?

I want the first run of my app to create an MDB and tables if not already in existence

 

[bboffin]

Yes. Look up details of the ADOX ActiveX object. This will happily create an empty .mdb file and allow you to populate it with tables etc.

FYI the file doesn't even have to have the .mdb extension.



Bob Boffin

 

[SimonTheSponge]

Thanks Bboffin, Have founbd a few threads that point the way. Any idea where I can obtain the adox control, it doesn't appear to be in MDAC 2.6, 2.7 or 2.8

Cheers

 

[CassandraR]

Hi Simon:

ADOX is included in MDAC_TYPE.EXE, which can be downloaded from MS. On webpage,

http://support.microsoft.com/?kbid=828396,

under the list of files included in 2.8, you will find MSADOX.DLL listed.

Cassandra

 

[koala15]

Another way is to use Access to create the tables etc etc though the Access GUI. Then upload the MDB file into the application's resource file using the IDE. At run time, if the DB needs to be created just copy DB part of the resource file onto the disk.

It is simple and very easy.

Greg.

"Life is full of learning, and then there is wisdom"

 

[SimonTheSponge]

Cheers guys and gals