Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Unanswered: Programatically building an Access database

    Does anyone know how to programatically push a Basic (VBA) module into Access?

    I have:
    - A utility I wrote that runs raw SQL commands against an (already existing) Access database. It uses ADODB.
    - An SQL file that builds all my tables and indexes.
    - An SQL file that builds my views and procedures.
    - An SQL file that populates the database.

    All I'm missing is a way to programatically push my VBA modules and my forms and reports into the database. Right now I have to manually import them or drag-and-drop them from the old version to the new version.

    Any ideas?

    DQNOK

  2. #2
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    441
    Check out http://www.datastrat.com/Code/DocDatabase.txt. The "opposite" method, would be LoadFromText.

    <grin> check out

    Application.SaveAsText 6, "", "c:\newdb"

    for the tables</grin>

    There's also the DoCmd.TransrerDatabase method.
    Roy-Vidar

  3. #3
    Join Date
    Apr 2007
    Posts
    2
    Thanks. I'll check it out.

Posting Permissions

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