Prevent import of tables and queries from secured mdb.

  • Thread starter Thread starter Ken
  • Start date Start date
K

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!
 
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
 
Back
Top