Print and Export confidential table data

[Bello]

Hi all,

How can I prevent users from printing and/or exporting confidential table data unless they do so through the form provided?

I need this for security purpose so that in this way I can trace and record every actions (exporting data etc.) done by the users.

Any advises would be highly appreciated.

Bello

 

[ghudson]

You will have to secure your db. Access security will allow you to set up workgroups and permission's that you can assign for each person. Ensure that you fully understand Access security before you attempt implementing it. Also, BACKUP your db before you attempt to secure your db.

There are thousands of posts of what to do and what not to do on this forum. Search the forum [security, system.mdw, workgroups] and learn from the others mistakes before you attempt to secure your db.

HTH

 

[Bello]

ghudson,

Thanks for putting me on the right track!

 

[Bello]

Hi Pat and all,

Thanks for your reply.

Now the problem is how do I remove all toolbars? I'm using swithboard to navigate among forms currently. Does it involve the startup property setting? or in more specific what else need to be done?

Bello

 

[ghudson]

'The below code will disable (hide) all menu bars and tool bars.
'Ensure that you have a way to enable (unhide) the menu bars
'and tool bars (transparent command button) before you hide them!

'this will disable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

'this will enable all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

'An added bonus is the right click option is disabled if the menu bars are disabled with the above code.

'Use the 'ShowToolbar' command if you need to display a tool bar or menu bar...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarYes

'This will hide a tool bar or menu bar when needed...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarNo

'This will hide the Menu Bar...
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

'You can also hide/unhide the database window with code...

'Hide the database window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

'Unhide the database window
DoCmd.SelectObject acTable, , True

'Check out this link to see how I disable the Shift key [from within the db]...
Disable the AllowBypassKey property

Visit this link for more tricks...
Hide all Access Toolbars and Menubars

'HTH

 

[Bello]

Hi all,

Oh yes..that's all I need ghudson! Now everything is working fine as I desire!

I set up the user-level security, disable toolbars at startup for anyone other than administrator...that's it!! Oh.. also thanks to Ricky Hicks as your codes on this forum enlightened me on how to enable/disable the bypass key.

As for the 'print screen' issue mentioned by Pat, I think that's really beyond my ability to solve so let's forget about it...


Thanks again to ghudson and Pat for your helps!

Bello