Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Unanswered: Identifying MDE / MDB

    I would like my ms database application to detect whether it exists as an MDE or an MDB. Would appreciate any help on how this can be done.

  2. #2
    Join Date
    Dec 2001
    Posts
    79
    Here's some code that should help:

    Function ref_IsMDE(dbAny As DAO.Database) As Boolean
    '* Returns True if the passed database is an MDE file
    Dim varRet As Variant
    On Error Resume Next
    varRet = dbAny.Properties("MDE")
    ref_IsMDE = (varRet = "T") And (Err.Number = 0)
    Err.Clear
    End Function

    Regards,
    Peter De Baets
    Peter's Software - Microsoft Access Tools for Developers
    http://www.peterssoftware.com

  3. #3
    Join Date
    Dec 2001
    Posts
    2

    Identifying MDE / MDB

    Thanks Peter.
    Much appreciated.

    Regards

Posting Permissions

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