Issues with password

[mb1980]

Hi all,
I have created a database and rather than use a FE/BE for different users there is only myself who modifies and another set of users who run reports) I have set it up with a switchboard for me and a form I have designed for the reports. Now the way I have worked it is that I have an admin password for me and a user password for the others with their access restricted to the form I want them to see.

This works great on my pc and I have setup a shortcut to the form for the others to click into for ease of use. Using my PC this works spot on, but when I go on any other pc on the network they do not have to log on at all and just go straight into the DB with full access to everything.

Any ideas on how I can sort this?
(other than go around every pc in the place and put passwords on )

Thanks in advance

 

[gemma-the-husky]

you either need to use the integrated security, which is stronger than a dbs passwoird, or write a front end requiring users to login