Create an mdb file using VBA?

[servoss]

How do I simply create an mdb file using code? I want to use a transferdatabase command to export data to a table (for import at another time), but this expects a file to exist already.

I've searched with no useful example - perhaps I've missed it, if so, please point in the right direction.

Thanks,
Tom

 

[mhartman]

Hello:

RunCommand (acCmdMakeMDEFile)

Should do it. Place this under a command button.

Regards
Mark

 

[servoss]

not so good...

got an error saying I could not open a new MDE with a current database open. Should I put the runcommand() right on the onclick event line - I placed it in the VBS module for the onclick.

Tom

 

[boblarson]

This will create a new blank database which you can then export objects to.

    Dim acApp As Access.Application
    Set acApp = New Access.Application
    acApp.Application.NewCurrentDatabase ("C:\Temp\YourFileNameHere.mdb")
    acApp.Quit

 

[servoss]

perfect!

this did the trick!

Thanks.