Prevent import of tables and queries from secured mdb.

[Ken]

Hi,

I'm using user-level security with Access 2000. Even
though I've secured my mdb, I've noticed that someone can
create a new mdb, and import my queries and table links.

I think this is because I have to give 'Read Design'
permission to tables and queriespermission in order for
anyone to read data.

I can't create an MDE, because I'm using code to force
reports to print legal size, which requires opening a
report in design view, which you can't do in an MDE -- and
even though I have the latest Office Service packs, my
report sizing is still getting lost...

Can someone please help me?

Thanks!

 

[TC]

MDEs do nothing to protect your data. They only protect your code..

If you want to prevent people linking to your data tables, you will need to
do >all< access to those tables via so-called "Run With Owner Permission
(RWOP)" queries. This is tough to establish, but will do what you want. You
need to read-up on Access security, with particuylar reference to using RWOP
queries.

HTH,
TC