Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Create a MDE file using VBA

Discussion in 'Information Technology' started by jj, Jul 28, 2006.

  1. jj

    jj
    Expand Collapse
    Guest

    Hi ng

    I use the following code to create a MDE file from vba. I have office 2003,
    but the database is build in Access 2000. It works fine on my computer. But
    when I run the code on a machine with Access 2000 - it does not work - any
    ideas?

    TIA
    jj

    The code:
    Function CreateMDEDatabase(strDB As Variant)
    Dim a As New Access.Application
    Dim strMDE As String

    strMDE = Left(strDB, Len(strDB) - 3) & "mde"

    a.SysCmd 603, strDB, strMDE
    Set a = Nothing

    End Function
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    MDE's require being built in their own format. Although the default format
    of 2002/2003 is 2000, you must convert to the 2002/2003 format to build the
    MDE, which then won't run on an Access 2000 machine.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "jj" <jj@get2net.dk> wrote in message
    news:uJ%23Jb0ImGHA.3468@TK2MSFTNGP03.phx.gbl...
    > Hi ng
    >
    > I use the following code to create a MDE file from vba. I have office
    > 2003, but the database is build in Access 2000. It works fine on my
    > computer. But when I run the code on a machine with Access 2000 - it does
    > not work - any ideas?
    >
    > TIA
    > jj
    >
    > The code:
    > Function CreateMDEDatabase(strDB As Variant)
    > Dim a As New Access.Application
    > Dim strMDE As String
    >
    > strMDE = Left(strDB, Len(strDB) - 3) & "mde"
    >
    > a.SysCmd 603, strDB, strMDE
    > Set a = Nothing
    >
    > End Function
    >
     

Share This Page