Creating a reporting tool - PLease Help

[arvindn]

Is it possible for a database to run a form without having access to that form's object design and code ? My intention is that i provide a reporting tool to an MS-Access application developer that consists of tables,reports and forms with the table containing the configuration (hence making my tool independent of the other developer's application and of his need to access the forms and reports) and the application developer being able to open forms and reports of my tool without going into their design and code.

If i need to elaborate my question then please tell me so , as i am banking a lot on my product.

i know very little about designing add-ins (if my question is related to add-in which i am unsure of) and security and if i need to know a lot then please point me to articles and links.

 

[dcx693]

The easiest way is to save a version of your mdb file as an mde file. An mde file simply compiles the mdb file so that the code and design of the database is not allowed.

Please note that this conversion is one way only - you cannot open an mde file and hope to reconvert it to mdb. Always save a version of your original mdb file.

 

[arvindn]

i have been misunderstood. I know about MDE files etc. etc.

Let's say i give u my reporting tool developed in Access (i.e. i give u my application) and i want it to work as part of your application but u should not be able to see my forms' designs and code. How do i do it?

 

[dcx693]

The only other way to do this is with Access' built-in security. Check out this link: Microsoft Access Security FAQ Available in Download Center .