Preventing import of tables and queries from secure 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!
 
I believe the only way you can prevent outside access to
your tables is to lock them down completely. Then to
allow the user view/update access to the data, your forms
and reports need to use querydefs with the WITH OWNER
ACCESS option. Basically what this does is to allow the
user to inherit your access permissions to the table when
they run a query "owned" by you. This method ONLY works
of course if all your SQL comes from stored querydef
objects. If you build SQL strings in code or use them as
control or row sources, you will need to replace all these
SQL strings with references to a stored querydef. Stored
querydefs are more efficient so this isn't a bad thing
anyway.

Creating an .mde won't solve the problem since the .mde
only makes code unavailable. It still allows complete
access to tables and queries. Your users may not have the
latest Office service packs installed. You can resolve
the issue by turning off the autocorrect feature as the
first thing when the db is opened. Look up this article
in the msdn library to give you details -
http://msdn.microsoft.com/library/?url=/library/en-
us/dnacc2k/html/acglobaloptions.asp?frame=true
 
Back
Top