Open a Database with Admin permision or view

[samuvk]

I have a database that my co-worker developed, but he is not here anymore.

I have a front-end and back-end. The forms are in the front-end, but when I open the front-end I can not access to the Design View.

When I open the front-end a form come up and I do not find the way to see the Design view. In the back-end I only can see the tables but not the forms and I need to changes some programming.

I tried:

1. When open the file and the security Warning message appear, Pressing Shift + Open at the same time. This worked for others files but not for this one.

2. He has a security mode and even I am accesing with Admin user I can not see the Design view.

Thank you so much for your help

 

[apr pillai]

You can open the Front-End Database but not able to go into Design View of Forms/Reports/Macros/Module etc. You are able to work with the database, Right?

If so, create a new Database and import all the Objects from the Front-End File. If the VBA Module is set with Password Protection then it cannot be imported.

 

[samuvk]

Thank you very much for your answer.

I tried to create a new database and import the form but I got the next error message:

You don't have permission to iport, export or link to "FormName"

To import, export, or link to this object, you must have read Design and Read Data permisions for it.


Thank you so much again

 

[boblarson]

So is this an MDE file? If so, I fear you are basically in trouble.

 

[samuvk]

It is a .MDB file

 

[ghudson]

Sounds like the database was secured with workgroup / user permissions. If so, you must have the .mdw file that was used to secure the database.

 

[samuvk]

Yes I have it, but I do not know what to do with it.

I am not able to see the security into the database, and when I open the .MDW file I only have queryes that give me the Group List and the User List.

I do not know how can create a user with Admin permits from the .MDW file.

Thank you very much again

 

[ghudson]

There might be one .mdw file for the users which has limited access rights and there might be another .mdw file that had the admin permissions to edit all db objects.

Are you sure you are opening the db with the .mdw file correctly? This would be with a custom shortcut and the Target property of the shortcut defines where the msaccess.exe file is, where the .mdw file is and the .mdb file is. Something like this...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "C:\Test\WorkGroup.mdw" "C:\Test\Frontend.mdb" /user UserName

Adjust that for your three files in your custom shortcut.

If that does not work then I doubt you will be able to get inside of your database without paying a company to hack into too. Assuming the file is not really a MDE disguised [renamed] as a MDB file.