Solved

No permissions for Database, but have .mdw file.  How can I edit it t gain acces to Db?

Posted on 2008-10-27
2
560 Views
Last Modified: 2013-11-29
I have an .mdb that a previous Access developer created. Unfortunately, the developer left no documentation and no security credentials.  : (  My boss has charged me with cleansing some of the data from the database and changing the security so that that databse can be used.  I do not have admin rights (or the admin password) for the database.  An MDW file was set up for use with the database. I do have the .mdw file.

I need to know how I can open and edit the database and make changes to  the security.  I don't have much experience with Access, so please be gentle.  : )

Thanks in advance.
0
Comment
Question by:Wannabe_21
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 22817018
"I need to know how I can open and edit the database and make changes to  the security.  "

Without the password / admin rights, you will not be able to do this. And we at EE cannot suggest anything that might be considered hacking.

Your best shot is to use the G word - and search for a service that can help you.

mx
0
 

Author Comment

by:Wannabe_21
ID: 22864585
resolved.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question