Hi,
Can you add a button on a form which when pressed asks you for a password to open the table containing the data? If so how do you go about it please?
Thanks
Hi,
Can you add a button on a form which when pressed asks you for a password to open the table containing the data? If so how do you go about it please?
Thanks
Users should not interact directly with tables and queries - just forms and reports.
Yes, what you want is possible but useless if you do not go to more rigorous measures to restrict access to Navigation pane.
Protecting database is a common topic. Have you done a search?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Code:vRet= inputbox("Enter password","secure area") if vRet ="" then exit sub if vRet="Password" then Docmd.openReport "rMyReport" endif