I have user that has two seperate wrkgroups on her computer. Is there anyway that I can have icon go to one wkgroup and another one goes to the other. I don't want to her go through the whole gammit step by step.

I am sure I am not the first ever had this problem. I just don't know how to go about it.

Any ideas?

In Access Help, look up "Command Line" to see options available from the command line.

if you create short-cut icons for each different DB, you can go back to open the icons via right-click to see what the command line looks like. I believe there is a -wkgrp option that allows you specify the workgroup to use when opening the DB through that icon. (Whereas a direct click of the .MDB file would NOT be able to support that function, as the launch mechanism for iconic vs direct launch slightly differ.)

Thanks Doc Man
Very interesting, I will give that a try. I will keep in touch let you know if I can make it work.

O by the way frist time grandpa here, wow what feeling. Aint it just great.

Well Doc

I could not find that wkgrp option. I tried a couple of diffterent ways and still good not make it happen.

Thanks anyway, dang always something

I'm surprised. I opened Access Help and asked for COMMAND LINE options. This came up right away. Is your database not an Access database?

/wrkgrp workgroup information file

Starts Access by using the specified workgroup information file. Applies to Access databases only.

As to grandpa, we are on our second grandson. He's 10 months old now and a real hoot. We lovingly call him "chunky monkey thunder thighs" because he's a little chubbie bubbie. He's happy and absolutely attached to his "grammie" who is his daytime sitter right now. Number one grandson is 12 (already? Sheesh) and getting into more mature things. But he was a lot of fun as a rug rat and is still a lot of fun now. Just a very different type of fun.

Here is the whole string for Office 2003, the Office directory will be different for other versions. Note the inverted commas -

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\SomeDirectory\SomeDatabase.mdb" /WRKGRP "C:\SomeDirectory\SomeWorkgroupFile.mdw"

Chris B

Thanks Doc Man and Chris

I just don't think it can be done.

Doc Man, I did get the "wrkgrp workgroup information file", but I don't think its possible to do it.

I was just trying to make it more easy for a user joining another wrkgroup, without going thru all of the steps. I was just hoping I could use Macro or ICON or something. But I can't win them all. Maybe some type of code would do it, but I am not that talented enough to even try it in code.

Here again thanks guys, it was a good shot

It certainly can be done. I do it all the time. The user doesn't join the workgroup, he/she can stay in the default workgroup. If you create a new shortcut - desktop - right click - new - shortcut, and put my line in it with the appropriate info, it will open access, attach it to the specified workgroup and open the file. Next time user opens access they will be in the original workgroup.

Chris B

Try using this product to create your shortcuts to the appropriate MDW file for the appropriate database. This makes it super simple to create your desktop icon to launch the database with the right mdw file:

http://www.headwaysystems.com/ShortcutBuilder.htm

Sorry guys, I have not got back to you. Been out the office.

Bob...........thanks for the hot tip on creating the desktop icon. I like that.

Ok, burrcm. I follow the directions. When I added the path, it still asks for my password when entering the other database. Now I thought, it should ask what workgroup I want to join. Maybe I’m missing the whole thing here, which is common for me.

Is it that I am missing something, I guess I am not quite clear on just how it suppose to work.

1. Here is my thought, if I go into another database, I first have to leave my workgroup and then join the other database workgroup. How far off base I am I?

1. Here is my thought, if I go into another database, I first have to leave my workgroup and then join the other database workgroup. How far off base I am I?

If you are using the shortcut method to open the database, you do not need to "join" the workgroup to do so. Use the right shortcuts and you can go between workgroups easily enough.

If your database is properly secured, it SHOULD ask you for a password.

If your database doesn't ask you for a password, it is not secured and in that case, why bother with workgroups at all?

Bob/Doc man

My database is properly secured, it does ask for a password. Let me give you example on how I thought it should work

2 separate databases on two separate Drives on the same computer

Drive a Drive B
Database (a) Database (b)
Workgroup (a) Workgroup (b)

What I thought, if I was in Database (a) and in Workgroup (a) and I wanted to go into Database (b) I would have to join Database (b) Workgroup. What my main intentions are, is not have the user go though all of the steps in joining another workgroup. Just use another shortcut.

According to burrcm, it can be done all the time, and I did use his method. Now I am not saying it does not work, I am just saying I am having problems make it work for me.

Now burrcm wrote:

Here is the whole string for Office 2003, the Office directory will be different for other versions. Note the inverted commas -

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\SomeDirectory\SomeDatabase.mdb" /WRKGRP "C:\SomeDirectory\SomeWorkgroupFile.mdw"


When he said "Note the inverted commas". Do you think he met to say the slashes (forward and back)? Because I did not see any inverted commas.

Yeah, he probably meant the backslashes and forward slashes. Now, I would highly suggest using that Headway systems program (it's free anyway) to create your shortcuts and then you should not have a problem.

No, I meant inverted commas. They are required around each section where a space may occur, such as in "Microsoft Office". Not sure why you can't see them. Here is the string again with X substituting for inverted commas (")

XC:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXEX XC:\SomeDirectory\SomeDatabase.mdbX /WRKGRP XC:\SomeDirectory\SomeWorkgroupFile.mdwX

Chris B

Bob/Chris

Once again thanks, I think I have got it now. OK Chris that makes sense to me now. I am about sharp as a Marble most of the time.