Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002

    Unanswered: Want to make mde file from inside access

    I want to program a button to make an mde file from insde the mdb with code. Anyone have any ideas ?
    I searched the archives but found mostly converting mde to mdb to get forms out of....
    Also found the following code:
    Dim accApp As Access.Application
    Set accApp = New Access.Application
    accApp.SysCmd 603, PathMdb, PathMde
    Set accApp = Nothing

    but does not work in Access 2003.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia


    Sorry, I have never tried to do this, but I am very curious as to why you might want to do that
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2002
    Well, I have a large database and make mods every night and have to create an MDE for distribution to workstations, and just trying to save a few keystrokes and time here and there.

  4. #4
    Join Date
    Dec 2002
    Préverenges, Switzerland
    the MDB cannot "MDEize" itself with 603

    you could use a separate .MDx & 603 to MDEize your .MDB but will it provide a huge saving of keystrokes on its own?
    ?? maybe a separate .MDx that performs all your distribution steps: 603; copy/ftp the MDE to wherever it is going; etc might be worthwhile.

    currently using SS 2008R2

Posting Permissions

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