preventing users to import data from another mdb file

preventing users to import data from another mdb file

am 31.01.2008 14:16:28 von thread

Hi All
i'm building a database in access and i want to restrict permissions.
from the access i can just limit the posiblity to unhide an hidden
table and in this way i can preventing the users from looking in un-
relevant data
my problem is how can i prevent the posiblity to import the data from
another mdb file
becaouse it is quite simple and visible to extract the information
from another mdb file
any ideas?

Re: preventing users to import data from another mdb file

am 31.01.2008 19:12:41 von BobH

On Jan 31, 8:16=A0am, thread wrote:
> Hi All
> i'm building a database in access and i want to restrict permissions.
> from the access i can just limit the posiblity to unhide an hidden
> table and in this way i can preventing the users from looking in un-
> relevant data
> my problem is how can i prevent the posiblity to import the data from
> another mdb file
> becaouse it is quite simple and visible to extract the information
> from another mdb file
> any ideas?

one way might be to build a custom menubar and don't include the
'import' function
don't allow database window view, force the app to open to a mainmenu
form
bobh.

Re: preventing users to import data from another mdb file

am 01.02.2008 00:34:07 von thread

On 31 ינואר, 19:12, bobh wrote=
:
> On Jan 31, 8:16 am, thread wrote:
>
> > Hi All
> > i'm building a database in access and i want to restrict permissions.
> > from the access i can just limit the posiblity to unhide an hidden
> > table and in this way i can preventing the users from looking in un-
> > relevant data
> > my problem is how can i prevent the posiblity to import the data from
> > another mdb file
> > becaouse it is quite simple and visible to extract the information
> > from another mdb file
> > any ideas?
>
> one way might be to build a custom menubar and don't include the
> 'import' function
> don't allow database window view, force the app to open to a mainmenu
> form
> bobh.

you can do it inside of your mdb but what is someone would like to
import the information from another mdb?
one way i found but still in a way problematic is to unhide the table
but when someone will select view hidden objects it the hidden tables
will appear