Hide a table in Access

  • Thread starter Thread starter jain
  • Start date Start date
J

jain

I have an mdb database this is kept at a common place accessible to every
one, I am making some changes in it and implementing separate username and
password for all users, this information is kept in a table ‘user’.
Now my problem is how I can hide this table from all other users so that no
one is able to see its contents.
I have tried it by creating a MDE but it is not helpful as it shows the
contents.
 
jain said:
I have an mdb database this is kept at a common place accessible to
every one, I am making some changes in it and implementing separate
username and password for all users, this information is kept in a
table 'user'.
Now my problem is how I can hide this table from all other users so
that no one is able to see its contents.
I have tried it by creating a MDE but it is not helpful as it shows
the contents.
Click to expand...

Are you on a Windows network? You could just grab the Windows loginName and
then you don't need to store passwords thus you don't have to worry about
your table being seen.

You can set its hidden property to true or prefix the name with "USys" and
that will hide it, but those steps would deter someone who knows a little
about Access exactly zero.
 
I have an mdb database this is kept at a common place accessible to every
one, I am making some changes in it and implementing separate username and
password for all users, this information is kept in a table ‘user’.
Now my problem is how I can hide this table from all other users so that no
one is able to see its contents.
I have tried it by creating a MDE but it is not helpful as it shows the
contents.
Click to expand...

Well, you can do a couple of things: as Rick suggests, change the name of the
table from User to UsysUser (the Usys prefix makes it a system table); and/or
rightclick the tablename in the database window, and view its Properties.
Check the "hidden" checkbox.

Either of these is about as secure as a $2.95 bicycle lock, anyone with a
modicum of Access knowledge and access to the full menus can undo it in
seconds; but it will keep casual users out.

If you have A2003 or earlier, consider implementing Access workgroup security:

http://support.microsoft.com/kb/207793/en-us

It's more like a Kryptonite bike lock (i.e. better than the dimestore version
but vulnerable to those with the right tools). For genuinely hard to break
security move your data to SQL/Server with a properly designed security
scheme.
 
Back
Top