Search results

Many thanks for your help CBrighton, all I have to do now is protect the back end to make it secure from unwanted users (presently anyone can just open it)

Excellent that works as well now thanks. But what about the design view button on the top tool bar? Obviously if one of the users clicks this then they can start editing my forms and changing stuff around?

OK so now I have control over who can actually open my DB (I just tested it with my colleague's machine). Now I need to restrict the admin controls but my DB doesn't have admin controls located on the actual forms - can I disable the design mode functions, creating tables function etc?

Sorry I have got lost again. Going to the query step - I normally make my queries in design mode but I cannot see where to type "WHERE tblStaff.EmployeeID=fOSUserName();"? I have also moved my text boxes off from my switchboard and onto a seperate form called "frmGrabUserData". Would it be...

Thank you very much for that and for your help so far - I will give it a try straight away. One quick question - should I split the database before this or does it not matter if I wait?

AHA! It works now thank you. So now I can see my log in name and my computer name. What do I do next? (I have presently put the text boxes on my switch board so should I make them invisible?)

Thanks - I have done this and the computer doesn't like it. When I view my form with the unbound text boxes on, it brings up the VB debug highlighting the first line of "Function fOSUserName() As String" in yellow and then highlighting "apiGetUserName" in blue.

Thanks for your reply. Unfortunately that link is assuming that I know more than I actually do - I am a bit lost when it comes to inserting code etc. However if the point is just to get the user names, I do already know all the user names that I would require to set my colleagues up - do I still...

The organisation is County Council so we probably havesimilar security to what you are talking about. Our secure logon names are basically firstname.surname and when creating a new user, this is the prefix I have used. Do you think what you are suggesting would be better in that case?

Hello everyone - I'm new. I am presently designing a database (Access 2003) for my team at work. The database is fairly simple in the scheme of things and will be used for keeping volunteer details plus training they have received etc. The DB will be used by 5 people including myself all of...