Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Cool Unanswered: Creating MDE for Secured DB Programmatically

    Hi Everyone-

    Sorry if this is a redundant message. I am new to this forum.

    Basically what I am doing is writing code that will compile my mdb file to mde format. The code looks like this:

    Dim objAccessApp As Access.Application
    Set objAccessApp = New Access.Application

    objAccessApp.SysCmd 603, strPath & "\TMPmde\TMP.mdb", strPath & "\TMPmde\TMP.mde"
    Set objAccessApp = Nothing

    This code works fine, but since all db's are secured, a login pops up. If anyone knows a way to pass the username and password to the new access instance or automate the login so that the user does not have to type his/her username and password everytime this code executes, it would make my application much cleaner.

    Thank you in advance for your help,
    Michelle

    PS: SysCmd 63 is an undocumented method that works very well for compiling the current database.

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    if you can somehow send the shift key then you might be able to suppress the login screen. I have never tried it but its worth a shot.

Posting Permissions

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