Package and Deployment

[gselliott]

I have developed an Access 2000 Database that is being given to another company (not happy about it but never mind!) to use.

What i am wanting to do is to set-up this database as an exe so they can install it on one of their machines, but i do not want them to be able to ammend or even see any of the forms, tables or queries etc.

I managed to create the exe using the Package and Deployment Wizard and installed this on a test machine. The problem i have found is that if the PC has Access already installed the user can view, ammend, delete any of the Forms, Tables etc.

Is it possible to create an executable that will not allow the users access to any of the code, forms, tables etc??

Hope someone can help as i have came to a dead end now!

Thanks in advance

 

[Fizzio]

Is it possible to create an executable that will not allow the users access to any of the code, forms, tables etc??

Nope, but you can make the Db into a MDE file which will limit their tinkering (But make sure that you keep a backup of your Mdb)

Search these forums for '.exe' or 'standalone' or other related words as it will bring up a hoard of results.

 

[gselliott]

Thanks for that i will have a search through!

 

[gselliott]

i had a go at saving the Database as an .MDE but i could still gain access to the forms and tables, is there anything i need to do before i save the Database as an MDE?

 

[ghudson]

You would have to use Access security and assign workgroups with permissions as to what you want them to do with your db.

Is the other company going to be allowed to modify the design of the db? If not, then Access security will prevent them from accessing what ever you do not want them to see. If you correctly set up the security.

Check this forum for Access Security & System.mdw and read the others posting to avoid the common mistakes.

Ensure that you backup your db before you attempt to secure it...just in case.

HTH

 

[gselliott]

Thanks ghudson i think security is the way to go as i don't want the other company to be able to modify the database at all. All i want is to enable them to add and delete records but nothing else!