Re: how to create a mdb file with a code?
You can't do it with a macro, but in code you would use:
Dim Newdb as database
Dim WS as workspace
Set ws=CreateWorkspace("MyJetWorkspace","admin","",dbU seJet)
set Newdb=MyJetWorkspace.CreateDatabase("MyNewMDB",dbL angGeneral)
For further information, look in Help for CreateWorkspace and CreateDatabase. You'll need to search first on the Workspace object/ collection and the Database object/collection respectively. Also, I believe that there may be some slight variations depending on Access version.
I hope this has given you some pointers.
Originally posted by hendra1211
how to create a mdb file with a code or macro?
Elmhurst Solutions Limited
Database Development and Consultancy