i want to be able to share my database with other company's but i dont want them to be able to view or have access my code...
is there a way to place some security on it??

You can create an .MDE version of your .MDB file: Tools -> Database Utilities -> Make .MDE File. This will compile and remove any human- readable source code from your modules. Each version of Access, however, can only make an .mde version of .mdb files that are formatted in that version of Access. So you may first need to convert you .mdb file to your version of Access (e.g., Access 2K2 and 2K3 use an Access 2K file format, so you may need to first convert your 2K formatted .mdb to your version of Access (2K2 or 2K3): Tools -> Database Utilities -> Convert Database.

HTH,

Bob

Hey Bob,

i'm trying to convert it to a .MDE file but after an hour my computer is still running at full capacity trying to convert this... i've now tried it on another computer and the same thing... do i need to purge anything why would this take so long... and cause my computer's CPU to run at 100%???

any ideas???

The two primary causes of problems when trying to create a .MDE are A) compilation errors and B) database corruption.

So 'bout all I can suggest is:

1. Will the mdb. compile? Open up the Visual Basic Editor (Alt-F11) and from the menu select Debug --> Compile. If it won't compile, fix your code.
2. Will the mdb. compact/repair successfully? If not, import all your objects into a new mdb. file.
3. Create the .mde on your local hard-drive.

Bob

Bob, i just want say thanks for all your help!!!!!!!

YOU ARE THE MAN!!!!

I can't thank you enough....

-Dale

LOL. Oh, no. I ain't da' man. Big Daddy Wills is da' man!!!!

But you're welcome Dale! :)

Bob