Help Work Group File

[mothi]

Hi I read all the posts regarding the workgroup file. The problem i am facing is i applied security to the database and it has work group file too.

But when i paste the database andworkgroup file on to a server ( its a network drive) where all the users would have access to the database. The database is linking to default workgroup file instead of the work group file i created.And to make it work , i need to go to each user's computer and manually connect the database to the appropriate workgroup file .

I want to connect database on the network just once to workgroup file so that whoever tries to log in to the database will be connected to that workgroup file instead of defualt workgroup file. I used shortcuts , i could not make it work, may be i am doing it in a wrong way. Please Help me

 

[ghudson]

You do not want to join a users computer to your workgroup file!

You must use a custom shortcut to open your secured db with your workgrop file. Something like this is all you need in the Target field of the shortcut...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "\\Server\Directory\WorkGroup.mdw" "\\Server\Directory\Frontend.mdb" /user UserName

If the user's can open your db without using your mdw file... then your db is not properly secured.

 

[mothi]

Hi Gudson, Thanks for replying in such short time . The security is working properly but the shortcut path which you have posted where do i have to paste that or what to do with that. Please Help me regarding that. Please explain that step ( target field)

 

[SOS]

I find using the Headway Shortcut Builder (free) is a quick and simple way to build your shortcut that you need to give to people.

 

[ghudson]

Hi Gudson, Thanks for replying in such short time . The security is working properly but the shortcut path which you have posted where do i have to paste that or what to do with that. Please Help me regarding that. Please explain that step ( target field)

Right click on your database file, select the Create Shortcut option. Then right click on the new shortcut and paste your target info into the Target field of your new shortcut. You will have to adjust the parts pointing to your db and mdw file.

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "\\Server\Directory\WorkGroup.mdw" "\\Server\Directory\Frontend.mdb" /user UserName