Question Import objects from a secured database

[zabronm]

Hi All, I have inherited a legacy (.mdb)database secured by a "Security.mdw" file.

I need to upgrade the database to improve current features and add more functionality. I am now using Access 2013-2016, on Windows 7, hence the security file (ULA) technologies no longer exist. Thus I have created an empty database, but each time I try to import objects, it displays the messages that I have no permission to use the database onjects.

Can someone please assist on how I can import objects from a secured database. I have both the Secure.mdw and the .mdb file, but I am not sure how to work around to recover the objects and the data.

Please someone ... please assist.

 

[JHB]

Maybe the link can give you some idea, read post #2.
https://access-programmers.co.uk/forums/showthread.php?t=40338

 

[zabronm]

Thank you jHB; but in my case, when I start the database, it does not even ask me about login credentials, so the above solution does not apply in my case. OR, is there a way that it can display the login screens for me?

Please assist...

 

[JHB]

I'm a little confused - I thought you were able to open / work in the database, but could not import objects from it, but You're even not able to open the database?

 

[The_Doc_Man]

It has been a while since I dealt with those, but...

If you can open the database, you can EXPORT from it to an unsecured and otherwise empty database file. If you cannot open the database at all, you are pretty much out of luck, particularly if the subject database permissions had been set to disallow access by SYSTEM (the default account for a new .MDW file). And that disablement WAS a recommended action for securing .MDB files with user-level security.

 

[Cronk]

You can use command line parameters to open as Admin

  C:\Path\msaccess.exe C:\databasePath\YourDB.mdb /user AdminName /pwd YourPassword