Secured MDB file

[Cal Miyatake]

I support some customers in our domain who are using an
old Win95 computer that has Office97. On that computer is
an access (mdb) file created by someone who has long since
left the department. It is secured but I can not find a
secured workgroup file. Only the System.mdw exists.
While it resides on this computer, the user can open and
work it fine. But, now that she is getting a new Win2k
computer and has copied the mdb file to it, it does not
open. It displays a message about ...not being able to
convert the file or a message stating that she does not
have the permissions to open it. The creator of this file
is not with the department any longer. How can we reset
the security or somehow get into it to allow her to use it
on the Win2k computer. Is there a utility or backdoor to
release the security so that we can get this file to work
on the new computer?

 

[TC]

The win95 pc might have some *other* workgroup file (not system.mdw) that
must be used to access the secured database. If so, you may need to copy
that workgroup file (as well as the database) to the new pc, & make sure to
use that workgroup file when opening the database.

HTH,
TC

 

[Barry Edmund Wright]

Calvin,
Check the properties of the icon that is used to open the database on the
Win95 machine to see if it points to an *.mdw file mentioned. If not then
check to see what the default *.mdw file is by running
C:\Office2000CD\PFILES\MSOFFICE\OFFICE\1033\WRKGADM.EXE If it is the
system.mdw file in C:\Office2000CD\PFILES\MSOFFICE\OFFICE\1033 then I would
copy that system.mdw file located in then
C:\Office2000CD\PFILES\MSOFFICE\OFFICE\1033 to the directory of the Win2000
machine where the database is you are trying to open. I would also rename it
the <nameofthedatabase>.mdw then create a new icon to open the database with
the following command line (substitute the name of the database and
directory name for the one name of the database and directory name you are
using) "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\databasedirectory\datebasename.mdb" /wrkgrp
c:\databasedirectory\databasename.mdw
Double click the icon, you should get the logon screen.

If this doesn't work there is lots of other things you can do to fix the
problem. We have only scratched the surface above. So let us know what
happened because we can help you get in, so don't worry. If you want to you
can contact me directly: (e-mail address removed)

 

[Calvin Miyatake]

Tried the recommendation. However, I was able to import
all but one table into another blank database. I suspect
the one table in the database may be the key to my
problem. Is there a utility that would allow me to import
all tables, queries, etc. or , at least, most of it?

 

[Cal Miyatake]

Does the file have to be an MDW file? There are other
files listed (mdz, mde, etc).

 

[Barry Edmund Wright]

Calvin,
So you imported ALL the database objects? Could you actually see and select
the table that did not import?

If you couldn't see it, then before copying the database over to the Win2000
machine make sure Tools/Options under View tab has the Show Hidden Objects
checked.

 

[Barry Edmund Wright]

Calvin,
How many files are in the Directory where the Access .mdb database is
residing and what are they. That I'm wondering is, is this a Backend,
Frontend setup or is there a .mde database that holds the code and links to
another database .mdb file where the tables are.