PLEASE HELP

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I have a CD containing a 1997 Access Database. The CD
contains a few files:

1) smalldb.mde
2) smalldb.mdb
3) system.mdw
4) data.mdb

Every time I try to open these files I get permission
error messages. How do I link these files together.
Additionally I only have Access 2000 and the database is
built on 1997.

Please try to be as specific as possible with you
instructions.

Thanks in advance,

Mike
 
The smalldb.mdb is the original database from which the smalldb.mde has been
built. Thus, any design changes are made to the smalldb.mdb file and then
that database creates a new smalldb.mde file for user use. Generally, the
original smalldb.mdb is never given to the users.

The system.mdw is the Workgroup file that contains any username and password
data that has been set against the execution of the mde. The data.mdb is
most likely the backend database that would contain only the tables that are
used with the smalldb.mde.

Note: You need to reset all copied files from the CD from read only. Right
click and remove the Read only checkbox.

What you need to do is copy the system.mdw file to a same place of the
data.mdb. You need to locate the WrKGrpAdmin.exe, usually at this location:
"C:\Program Files\Microsoft Office\Office\1033\WRKGADM.EXE". Once you invoke
the executable you need to connect to the System.mdw file that you copied to
the location of the data.mdb. Once joined you can try to open the
smalldb.mde. Hopefully whoever created this file has placed code to relink
the files in the smalldb.mde to the data.mdb tables. If not, open the
smalldb.mdb instead; relink the files using the Linked table manager.
However, be aware that you may be required to enter a username and password.
If you do not have this information you will not be able to open the
original database. This method ensures unauthorized users from acquiring the
databases file information.

Hope this sheds some light
 
Back
Top