Hiding Code

[joatmofn]

I have an access application that I developed for a customer. While some of the code is unqique to their application, some of it is re-usable which I use in other applications. If I turn the application over to the customer, is there a way to keep my re-usable code out of their hands?

thanks

 

[dhulbert]

Save the database as an MDE file that locks all of the code away from prying eyes and fingers.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[EBGreen]

Depending on your contract with them, they may legally own the code.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[joatmofn]

Yes, that's what we do. The difference now is they want to make code modifications and reports themselves. I just want to protect my own code from ending up where it shouldn't be.

 

[joatmofn]

There is no contract.

 

[EBGreen]

Then you need to get a contract. Without one, you would have a very hard time bringing a suit against them if they get around whatever protection you put in place.

On a second point, if they want to be able to modify reports etc. Then the only way I know to protect your code is to make it flexible enough to handle dynamic report generation then hide it in an MDE as was already suggested.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Remou]

I guess you could put your private code in a separate database and turn this into an mde. The mde could be included as a reference in the customer database.

 

[PHV]

Why not simply protect your VBA project with a password ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[joatmofn]

I don't mind that they change the code unique to their project. It's the code that I use to control browsers, etc. that I use in all of my applications. I think the suggestion of a separate mde for my code might be the way to go. I need to do an example to be sure though.

 

[joatmofn]

I exported some of forms and queries to a separate mdb file and linked them to the backend tables. Then I went to the main mdb file and removed the exported forms and queries.

From the main mdb, how do you reference forms and queries that are in a separate database?

Thanks

 

[Remou]

If this is part of storing your private code in a separate mde, I do not think it will work for forms and queries. You would need to remove the code from the forms, and the SQL from the queries and store that. If you can give your reason for wishing to do this, it may be possible to provide better information.