Secure a single table in Access 2000

[mnathan]

I wouldl like one table to be password control without having to use ACCESS method of security. In my database, I will have a rates table, which should only be viewed by the financial administrator. Is there any other way, other than using access workgroup.


Access 2000 running on window 2000 and XP.

[nico5038]

I code my own Logon for in general, but you could also use a trick.
Just place a "dummy" label (or image) on your form and add to in't OnClick event the opening of the special form for the financial administrator.
When you tell him only about this it's rather safe...

Nic;o)

[ADezii]

I wouldl like one table to be password control without having to use ACCESS method of security. In my database, I will have a rates table, which should only be viewed by the financial administrator. Is there any other way, other than using access workgroup.


Access 2000 running on window 2000 and XP.

Set the Hidden Attribute of the Rates Table to True (Select Table, right click, Properties, Hidden (x)). This Table will not be visible to anyone unless they know how to turn this Attribute back on. In any visible Text Box on the Form, place the following code (a little trick I use in similar circumstances):

Private Sub Text31_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Shift = 3 And Button = 1 Then
  DoCmd.OpenTable "tblRates"
End If
End Sub

When the User holds the SHIFT and CTRL Keys down and left clicks on the Text Box, tblRates is opened.