And, although it is not now an issue, much of the information about the
forms and reports can be retrieved programmatically from the MDE, all the
property values, including the RecordSource, and the property values for the
Fields they contain, as well -- I do not know of any software, however, that
can regenerate source from the "compiled" tokenized code because much of the
information no longer exists in the tokenized code.
But, an experienced Access developer can probably re-create the forms (and
the entire front end) rather quickly, once you have the data available.
BTW, unless the terminated employee has "rights in data" to the database,
legal action can be taken against him/her. If he/she does own the database,
then he/she can take legal action against whoever breaks security. It would
be best for you / your client to get sound legal advice before proceeding,
in any case.
Larry Linson
Microsoft Access MVP
"Todd D. Levy" <us**************@spamex.com> wrote in message
news:MP************************@nyc.news.speakeasy .net...
My situation is as follows:
A terminated employee is preventing my client from getting their data.
An MS Access 2000 database, split into FE & BE.
The FE is a compiled (MDE) file with no source code available.
The BE is an un-compiled (MDB) file that is encrypted and password
protected; the password is not known.
The client is only interested in the actual data, so the FR is
irrelevant at this point.
Is there any way to break the encryption/password protection on the BE
so the data can be extracted?