Link to home
Start Free TrialLog in
Avatar of thimerion
thimerion

asked on

VBA code to create empty .mdb file

Hi all,

Someone has the VBA code to create a new empty .mdb file?

Regards, Tim

ASKER CERTIFIED SOLUTION
Avatar of cjswimmer
cjswimmer
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cjswimmer
cjswimmer
you can also add a password to the database by using:

    Set db = wsp.CreateDatabase("C:\YourNewDB.mdb", dbLangGeneral & ";pwd=YourPassword")


and the dbLangGeneral is optional (the default language will be used if this is omitted) so you really could just use:

    Set db = wsp.CreateDatabase("C:\YourNewDB.mdb", ";pwd=YourPassword")