Import Table Problem

[Haytham]

Hi All...
In my database, I have a full security, so nobody can access tables and queries in design mode. I disabled the shift key as well.
When I submit it to my customers, he created a new dbs and imported the tables and queries from my dbs.
Is there any way to prevent importing tables by code or any other means...
Thanks a lot.

 

[jwindon]

I would like to know this too. Right now, I can right click tables, etc and "hide" them like folders. Maybe that is a start.

 

[Haytham]

Hi, Thanks for reply.
Right it is true. It'll disappear from the list after uncheck it. But in case of importing, easily all the tables and queries can be imported to a new dbs.
If it is MDE, then forms,reports macros and modules can't be imported but not the tables and queries.
Any more suggestions.
Thanks to everybody.

 

[Haytham]

Great deed. It works great. Thanks a lot.

 

[Travis]

My experince with this has lead me do the following.

Disable the Shift
Hide the tables
Hide the Database Window
Distribute FE as an MDE
Password Protect the Backend
Use another Extension besides MDB for the backend.

Unfortunatly in order for the Password on the backend to work you will need to create a DLL in C++ or VB so that your FE can still link to the Backend without having to give the Password to the User. The DLL is simple it just passes an Identifier and returns the password. Since the FE is an MDE File it is very difficult to see the code (Not Impossible just difficult)

 

[Haytham]

True Travis.
Thank you