Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    49

    Unanswered: how to create a mdb file with a code?

    how to create a mdb file with a code or macro?
    hendra gunadi

  2. #2
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244

    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?
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •