Hello, one of my friend bought a company and acquired databases with it.
However, he was only given .ade files which are locked and now need to be
modified. Is there any way .ADP files could be generated so we can see the
design? Any other suggestions would be appreciated.
From the HELP file:
Saving your Access project file as an .ade file prevents the following
actions:
Viewing, modifying, or creating forms, reports, or modules in Design
view.
Adding, deleting, or changing references to object libraries or
databases.
Changing code— an .ade file contains no source code.
Importing or exporting forms, reports, or modules. However, tables,
data access pages, views, stored procedures, database diagrams, and
macros can be imported from or exported to non-.ade Access projects.
Considerations if you need to modify the design of forms, reports, or
modules
Be sure to save a copy of your original Access project file. If you
need to modify the design of forms, reports, or modules in an Access
project file that you have saved as an .ade file, you must modify the
original Access project, and then resave it as an .ade file.
You won't be able to open, convert, or run code in an Access 2002 or
later .ade file in future versions of Access. The only way to convert
an Access 2002 or later .ade file to a future version will be to open
the original Access project that the .ade file was created from,
convert it to the later version of Access, and then save the converted
Access project file as an .ade file.
In other words... you can't. If you cannot obtain the original .adp
files from which the .ade files were generated, you're out of luck -
the original code *simply does not exist*.
John W. Vinson[MVP]
