Search results

Hi , I post a few threads earlier but i decided to take the shortcut route. THe only question i have is that if users have access executable in different folders . I do not want to change the target path in shortcut for each user. I need some code or a batch file to recognize the access...

Hi , THe user will be running the database off the flash drive. it is secured and the workgroup file is also on the flash drive but i will be hiding it. It is mandatory that they have to run the database off the stick. they cannot copy DB on the local desktop and run them . So my...

Hi , I have a secured database. and I want the database to be linked to a specific workgroup file. I do not want to use shortcuts where i can link the shortcut to a specific workgroup file. I want the database to be linked . I know i can do that through VBA . COuld anyone help me out here...

Hi I have a secured database , i will be deploying the database to 14 users in Flash drives. So i will be having a shortcut in the flash drive and i will hide the main database in the flash drive. IN the short cut target path , the access executable path could be different in user computers...

Hi I created the shortcut for the secured database and done with filling up the target fields with correct path leading to the database. But as you know The path has to be like this C:\My Computer\Local Disk C\ Program Fiels\ MS OFfice\ Office 11\ MS Access .Exe wrkgrp........ THe...

Hi I created the shortcut for the secured database and done with filling up the target fields with correct path leading to the database. But as you know The path has to be like this C:\My Computer\Local Disk C\ Program Fiels\ MS OFfice\ Office 11\ MS Access .Exe /wrkgrp......... THe...

Please Help me . I looked at ghudson's solution and a lot other threads too. But I need to disable F11 and shift key depending up on the user group . I mean if the admin log in to the system the shift and f11 should work , he should not have to enter any password or click on the hidden...

Thank you vbaInet.

Hi , It is working and I pasted the code. Please check whether it is good or not so that i should not have any problems in the future. Thanks A lot to VBAiNet , SOS, Ghudson Dim UserName As String Dim curgroup As String Dim GroupNames(10) As String Dim ws As Workspace Dim usr As User...

How to modify the code . Please let me know about that.

It is actually returning the correct groups when i logged in as admin , groups returned were Admins and Users when i logged in as user , groups returned were Users . So how come the code is hiding toolbars for both of them .

i mean it is displaying the type mismatch error when i tried to use the msgbox code

not working

Its not working vbaInet ( got it right, )

HI VBAinet, I will get back to you whether it is gonna work or not in an hour because i am working on something else right now. Sorry about that.

Iam sorry how do you do that. I mean msgbox to show what group u r in

Hi VBAINET, thank you for replying in such short time. The code is actually working but the thing is Lets take an example " Admin1" belongs to both "Users" and "Admins" . So thats why it is hiding the toolbars because the user does belong to both groups. I need to use...

All tool bars should be visible to all the users in "Admins " group All tool bars should not be visible to all the users in "Users" group . But it is hiding all the tool bars for both groups . Please Help me What i figured out is that all the Admin Users belong to both "Admins" and "Users"...

Hi VBAINET, Thanks for the reply , But the code will work for all the users irrespective of Admins and Users. I need the code to work only for the users belong to "Users" group but should not work to users in"Admins" group so thats why i need to address the group in the...

Hi, I applied security to my database. It is secured now and the shortcuts are also working fine. I need to write the code like to disable menu bar, toolbar depending up on the user group rather than on the current user. I need to enable all the toolbars, if the user belongs to the...