Workgroup Security

[Andy B]

Might be a stupid question but here goes.

I have successfully created my own private workgroup and have set up security levels for 4 users on one access programme that l have written.

I have a second access programme that l use with the same users, however l want to set different user parameters, can l set a second workgroup up as l did the first.

Is two workgroups possible on the same machine ?

Regards

Andy B

 

[ghudson]

You can have as many workgroups as you want. Just use a custom shortcut to open each secured db. The target field of the custom shortcut will be used to determine which workgroup file and db is used.

Like this [all on one line]...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "X:\WorkgroupFile.mdw" "X:\DatabaseFile.mdb" /user UserName

 

[Andy B]

Workgroup Security.

Thanks for the reply,

However l am a little confused. Where does your suggested coding go ??

I expected to create a second workgroup from within my DB through the work group administrator is this not the corect method ??

Andy B

 

[ghudson]

Do not use the Workgroup Administrator to "join" a computer to an Access workgroup file! That would force a user to log into your workgroup every time they want to use Access, even for a new Access.mdb file. Use a custom shortcut to open the db with the desired workgroup. I have a sample of a shortcuts "Target" field in my previous post above.

 

[The_Doc_Man]

Andy B - just so you will understand what GHudson is telling you better (if you are still confused...)

Find an icon that opens something other than another folder. Anything. Doesn't matter what. But it would be better if what it opened was a program.

Right-click on the icon. On the pop-up menu, select Properties. Now look through the tabbed items on the resulting dialog box to find the Target. It is editable and GHudson is telling you what to put in it. This is not Access code. It is WINDOWS code that he is giving you.

 

[Andy B]

Workgroup Security.

Getting closer to understanding this (I think)

I have a shortcut on my desktop that has the Target box you speak of.

What is the X alluding too?

I have assumed that the "WorkgroupFile" and "DatabaseFile" are for me to substitute, do l do the same with the user Username?

Andy B

 

[ghudson]

Yes, substitute the "strings" to what works for your situation. I have colored the ones you need to update [change].

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "X:\WorkgroupFile.mdw" "X:\DatabaseFile.mdb" /user UserName

 

[The_Doc_Man]

What is the X alluding too?

The Target box contains, essentially, the MS-DOS equivalent of the command line that runs the target of your icon. So where the Target box says, in part, ...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"

You are running that program in that path.

And the part that follows /wkgrp is ...

"X:\WorkgroupFile.mdw"

where X becomes the drive letter AND PATH where you keep your MDB file. You know this because the next part of the target string points to the MDB itself...

"X:\DatabaseFile.mdb"

Note that X: (whatever it is) generally has to be the same for the .mdb and the .mdw file - but technically, GHudson should have made one of them a different letter because when you use the /wkgrp switch, you are not bound by the "same directory" convention.

Of course, the last part of the line GHudson showed you is the username you want to use when you log in, and that name must exist in the selected workgroup file.

 

[Andy B]

Thanks both.

Thats another wieght off my mind.

Slowly ever onwards !!!!

Andy B