Topics Search

Open a password protected MDB/MDW

Open a password protected MDB/MDW
Views: 190
In the past I've developed several forms, reports, VBA and tables using Access 2003. This was in a previous job and 4 or 5 years ago.
Now I have a task I need to do and I went back to this DB. The problem is I have it tightly secured and I cannot remember username nor password for this!

If I try to open the MDB alone I get an error message saying I don't have permissions. If I try to open the DB using the shortcut which points to the MDW, I get the login screen but again, I don't remember the username and password.

I also tried to import the DB bjects to a new DB (I'm in Access 2007) but again, no permissions screen comes up.

I checked online and found some softwares that are able to recover the password but for such a lame think I'm not willing to spend 20 USD
Sponsored Links:

Similar posts...

 

Not that Group Policy issue, Access2007 to open password-protected 2003 mdb.

Not that Group Policy issue, Access2007 to open password-protected 2003 mdb. Icon
I am trying to with 2007 open a password-proteced mdb file which I believe was created in 2003. In 2003, I can open it by adding username and password into it's command line. Although I have no permissions in design, I do can debug this program and check data. But when I tried to do this the same way in 2007, it always came up a logon window aske me username password, I can't get throught by inputting the right user/pwd pair, it said invalid username or password.

I guess It's not the group issue as other threads has said, because it doesn't come up the user/pass prompt window when opening other files. And I tried to delete that system.mdw file but no use.
 

Find out if remote db is password protected

Find out if remote db is password protected Icon
using VBA, is it possible to detect if a db is password protected? Reason being-

I have an application that allows you to browse to a separate database and connect but, if the seperate db is password protected, then there may be issues so by detecting if a password is required, I would use a password form
 

Convert Password Protected Access MDB File To CSV Format

Convert Password Protected Access MDB File To CSV Format Icon
Export Microsoft Access MDB to CSV is a freeware app utility which allows database users to instantly convert MDB database file in CSV (Comma Separated Value) file. As database tool are not abound, using this app would be extremely useful to export database tables into CSV format which is widely used and can be viewed with a simple text editor. Apart from mere exporting MDB file, it also lets user convert ‘password protected’ MDB file in CSV, CSV separated with tab, and CSV text qualifier format along with revealing the password.
 

Using VBScript to open password protected db

Using VBScript to open password protected db Icon
Does anyone know what to write on a VB Script file to open a password protected db and run a macro?
 

how does mdw work?

how does mdw work? Icon
people,

I have a question:
I have a database and a mdw file
is it ok to rename my database? or do I get in troubel with the security?
does the mdw refer to my database?

example:
my database name = ralph v1.0.mdb
I make some adjustments and I rename my database to ralph v1.1.mdb
is this ok or do I get in trouble
 

Access security ODBC to SQL Server

Access security ODBC to SQL Server Icon
Access 2002 on XP
I have a secure? client linked to an ODBC SQL Server 2008 db using an mdw file. My question is, if a user has access to the client via a password, what stops the same user from creating another blank mdb and using the same mdw in a path statement to open the data base (SQL Server
 

System.mdb or System.mdw?

System.mdb or System.mdw? Icon
Why [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes] "SystemDB"="System.mdb" isnt path and it isnt a mdw?

How can I use this system.mdb from HKEY_LOCAL_MACHINE?

I only get use "SystemDB"="C:\\Documents and Settings\\riella.cgr\\Dados de aplicativos\\Microsoft\\Access\\System.mdw" from [HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\A ccess\Jet\4.0\Engines].

I alredy change [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes] "SystemDB"="System.mdb" to "SystemDB"="System.mdw", "SystemDB"="c:\System.mdw" and "SystemDB"="c:\System.mdb" but I dont have any result
 

What should I do to protect Ms Access (.MDB ) file?

What should I do to protect Ms Access (.MDB ) file? Icon
I have developed a small desktop application using visual basic 6 and Ms Access 2003 as back end. Database is password protected and contains sensitive data. As many password retrievaltools are available, What should I do to protect Ms-Access (.MDB )
 

Access Macro

Access Macro Icon
I have a requirement for exporting one of the Access 2000 password protected mdb table data into a csv or tab delimited file on a daily basis .
Please let me know what is the best way to do it .

Also

1. Will macro help in extracting data for a particular date in table(daily basis)
2.Can macro helps in extracting data for this password protected mdb.
3.Any other way .vbs or something ?
4.Some examples if possible
 

Multi-user security in Access 2003 with Windows 7

Multi-user security in Access 2003 with Windows 7 Icon
I have a DB in .mdb file created with Access 2003 (one file only, no F/E and B/E). set permissions etc. It works fine as long as I am using shortcut like this one:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "S:\YourSystem.mdb" /WRKGRP "S:\YourWorkgroup.mdw"

or open my .mdb file directly.

When I open my .mdb file using different user account in Windows, it uses default workgroup information file, and no security is applied.

but I can easily bypass multi-user security by deleting workgroup information file. I think I am missing something here.

I guess I have to distribute the shortcut among users. How should I secure .mdw and .mdb file in system level,