I am at the edge of my understanding here and I don't know how to accomplish what I need to do. Basically I am trying to take a secured database and unsecure it programatically. This means I need to export all the object into a database with default access security. I am trying to do it in a VB application. I have no problem creating a secured workspace, but I can't seem to append it the current application object nore can I seem to create a new application object and change the systemdb file and log into it in order to run docmd in the log in user.
The code below is one version of what I have tried, which doesn't work of course.
Set mappMSAccSource = New Application
mappMSAccSource.Visible = True
mappMSAccSource.DBEngine.SystemDB = txtSecurityFile
Set mwsSecure = mappMSAccSource.DBEngine.CreateWorkspace("SecureSource", gstrDBOwnerAccount, gstrDBOwnerPwd, dbUseJet)
databasetype:="Microsoft Access", _