preventing users to import data from another mdb file

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?
thread [ Do, 31 Januar 2008 14:16 ] [ ID #1920923 ]

Re: preventing users to import data from another mdb file

On Jan 31, 8:16=A0am, thread <yaniv... [at] gmail.com> 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.
BobH [ Do, 31 Januar 2008 19:12 ] [ ID #1920934 ]

Re: preventing users to import data from another mdb file

On 31 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 19:12, bobh <vulca... [at] yahoo.com> wrote=
:
> On Jan 31, 8:16=C2=A0am, thread <yaniv... [at] gmail.com> 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
thread [ Fr, 01 Februar 2008 00:34 ] [ ID #1920950 ]
Datenbanken » comp.databases.ms-access » preventing users to import data from another mdb file

Vorheriges Thema: Access 2003 remove digital signature
Nächstes Thema: VBA Editor