Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: make MDE from another MDE

    i'm about to embark on a suicide mission.
    any hints?

    scenario:

    given blah.mdb (...which i would prefer to be password encrypted)

    run widget.MDE that...

    opens blah.mdb (is it possible to open password encrypted .mdb if password is known?)
    'some setup code runs in blah.mdb (in startup form .open)
    convert to current database version
    idea: syscmd(715) to get the version then
    idea: syscmd(605, ??) ...can this convert to current version, i've only seen convert to A97 examples?
    close blah.mdb
    make blah.mde from blah.mdb (password to .mdb is known, no password desired for blah.mde - is this possible?)
    idea: syscmd(603)
    close anything access that is open (probably the blah.mdb that restarts after the make mde)
    open blah.mde
    close blah.mde
    ---done---

    grateful for ANY comments.

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hey Izy

    I replied to this last night and the flipping link went down as I submitted. Just some musings really...

    Quote Originally Posted by izyrider
    opens blah.mdb (is it possible to open password encrypted .mdb if password is known?)
    Yep - OpenCurrentDatabase method of Application object includes username and password args.

    Quote Originally Posted by izyrider
    idea: syscmd(715) to get the version then
    idea: syscmd(605, ??) ...can this convert to current version, i've only seen convert to A97 examples?
    Dunno But Wayne has been documenting the, um, undocumented syscmd commands.

    Quote Originally Posted by izyrider
    make blah.mde from blah.mdb (password to .mdb is known, no password desired for blah.mde - is this possible?)
    idea: syscmd(603)
    I would imagine you could create the mde, open it with an application object again (using the password) and then turn the encryption off.

    Quote Originally Posted by izyrider
    close anything access that is open (probably the blah.mdb that restarts after the make mde)
    You could use API but probably easier to just keep track of what you have opened and close off each one individually.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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