?
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
Medium Priority
?
574 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 750 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

801 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