Don't know if anyon can answer this question but I am about to set up security
for a database and the last time I did this any database that opened asked
for a username and password. How do I prevent this?
another question is that this is a multiuser database and I have done a frontend
with the forms and linked all the tables to another database, lets call it
the backend.
Could I just add security to the backend and then everytime someone opens
the frontend they are inflicted with the security because the tables are
all linked to the secure backend database. Will this work? it would be much
easier than trying to set up security in every database frontend I set up.

Thanks for any advice on this. i have looked up the frequently asked questions
in microsoft but can't find simple answers on this! someone with some experience
might be able to help me here!