Securing tables

[Access security]

I have created an application in microsft acces 2003 and created MDE files
as it is one cannot import the forms but can import the tables and queries ,
how can I stop people from importing tables.
Is it different in access 2007
does access 2007 have MDE file, is it east to upgrade.
if I but Visual sudio which one do I have to buy to sort out this problem
I understand that in access 2007 one can download acces run time for free
If I do that can people impor the tables , it is very important for me to
secure the tables since most of my work is in the data.

Shmuel

 

[Tom van Stiphout]

On Thu, 27 Dec 2007 02:16:00 -0800, Access security

If the security of the data in the tables is of paramount concern to
you, you can't use MDB/MDE. Rather you would use SQL Server (the free
Express Edition comes to mind) so you can apply strong security.

Better to decide these issues BEFORE you create an application.

-Tom.