Solved

Workgroup Security system.mdw

Posted on 1998-10-26
2
566 Views
Last Modified: 2006-11-17
I have salvaged an access .mdb and associated VB application, however I am unable to view the database tables because of a security problem.  How do I add myself into workgroup securty?  I have the .mdb and the system.mdw
0
Comment
Question by:antisocial
2 Comments
 
LVL 2

Expert Comment

by:Poddy
ID: 1966752
you need to select the correct workgroup file - using wrkgadm.exe
then you need to log on to the database using a valid account and password - the admin would be a good account to have

0
 
LVL 3

Accepted Solution

by:
tcurtin earned 100 total points
ID: 1966753
hello antisocial,
If the original System.mdw file was deleted, try copying another one from another computer(hopefully, it is clean) to your Windows\system directory then use Wrkgadm.exe to join the group in that file. Start Access. When the database starts up go to 'Tools/Options' and on the View menu, see if the Hidden Objects feature is deselected. If so, select it. I would also try starting a new database and then importing all the objects.
Another idea is, go to Tools/Security/User and Group Accounts and see what the permissions are for Admin. Try to add yourself to the Admins group. If you can, then select the admin user from the top and click 'Clear Password'. Try to restart Access and try to log on as yourself you and try to export all the objects to another database(Saveas Export).
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Direct Mail software 4 42
Importing and Dropping Table in Access 11 24
Getting Run-Time Error 13 - Type Mismatch 3 26
can't find file error on web browser 1 13
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…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now