software to unsecure an Access 2000 database?
David McArthur
secured Access 2000 database but no special system.mdw file. The person who
secured the database has left and the client, when they open the database
file, is only allowed limited access to forms, macros or reports (denied
access to design view for each of these). The tables and queries are not
security locked.
Rather than rebuild all the many forms and reports again, I've been trying
to find a way to unsecure the forms & reports. I've been reading through the
many excellent postings in this group and downloaded the security faq.
Overall, my conclusions are that I need to find the username and PID for the
original creator of the forms, reports etc, and then re-create the original
owner's user with this same PID in the Admin group.
Can anyone recommend any software which can extract this info from the file?
I've downloaded trial versions of "Access Key" and "Advanced Office XP
passowrd recover" but I'm not sure whether purchasing the full "pro"
versions of either will recover the data I need.
Any suggestions, tips or advice would be very welcome.
David Brown
Albert D. Kallal
database that has not been secured at all. Your situation sounds like you
have a just plain old regular mde file,a and not a mdb file?
Assuming the above is correct, then all the code behind the forms and
buttons and code modules is NOT recoverable.
You might want to clarify what exactly your situation is, but are you taking
about a mde file?, or actually something that is secured via a workgroup?
Generally, a mde file is what I distribute to my users so they cannot change
the designs. A mde is really very similar to a compiled program in that the
source code is stripped away, and thus the forms, reports etc cannot be
modified (and you do not need, nor use access security in this case). In
fact, if the original developer looses the mdb file, then he also toast.
There are no password involved here, it is just a process where the oriental
source code is removed.
Hence, you might want to clarify what your situation is. There was a recent
post here about a utility that will recover the forms from a mde, but the
code/lodgic behind the forms is not recoverable if you are talking about a
mde file.
The other advantage of distributing a mde file (beside protecting the
designs) is that it tends to load faster as code in a mde file cannot loose,
or be-come UN-compiled, and cause large delays in program loading.
--
Albert D. Kallal
Edmonton, Alberta Canada
kal...@msn.com
www.attcanada.net/~kallal.msn
David McArthur
The files are "example.mdb" and "example-be.mdb" where "example" is the
database name. "Example.mdb" has the forms, reports & a module with table
links to the other file. "Example-be.mdb" has the tables and queries.
If I open "example.mdb" and try to select the design view of any form I get
the "You don't have permission to read ..... etc" message. If I open
"example-be.mdb" then I get full access to the tables and queries.
I presume that the databse was split at some time. There is also a file
called "adp1.adp" which is a mystery to me.
Any further comments would be most appreciated.
David
"Albert D. Kallal" <kal...@msn.com> wrote in message
news:9sOP9.48514$na.11...@news2.calgary.shaw.ca...
Albert D. Kallal
holds all of the security stuff. That file is the so called "workgroup"
file.
That file is usually called "some file".mdw
You could open the example.mdb and then go tools-security and check what
rights forms has, and also who is the owner of the database. Poke around in
there, and see who is the database owner.
It does sound like your application is secured (I just wanted to be sure).
Since you don't seem to have the original workgroup file, the you could
resort to some cracking program. But, I can't help you in that department.
David McArthur
David
"Albert D. Kallal" <kal...@msn.com> wrote in message
news:Od1Q9.196821$Qr.51...@news3.calgary.shaw.ca...