preventing tables from exporting to other mdb files.

[zareh]

Hi there,



I developed an access 2003 program and made it to .mde file.
It works fine on the clients computer. The problem is if he creates a new access mdb file and imports from my file the he can access to my tables.
Id there any way I can prevent this?

Cheers

[Amicron]

The only good way to protect your table is to encrypt your data... scramble it somehow with your own encryption code. I explain how to do this in my Access Data Encryption Seminar. Essentially you're turning all of the sensitive data into what looks like gibberish so that even if he does get hold of it, he won't know what to do with it.

The only REAL way to secure your data is to use a database server, like SQL Server. Since you're still with Access 2003, you can TRY using the User-Level Security Wizard, but I've found that's very easy to hack.