Shortcut to access using a workgroup

[Karen Dawson]

Help, I do not understand the error message.

Having looked at previous post, there is a way of creating a short cut to open a database on the network using a security mdw file which is also on the network.

The following is the paths I have typed into the target field.
It all looks fine to me.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "N:\Transfer\Karen\WorkingDatabaseVer2.mdb" \wrkgrp" "N:\Transfer\Karen\CLIENT DATABASES.mdw"

I get an error which says "The command line you used to start Microsoft Access contains an option that Microsoft Access doesn't recognize"

After clicking ok about 3 times it evenutally opens the database without the security.

Does any one have any ideas. Am I missing something really obvious.

Karen

 

[ggreg]

here is one of mine below:

C:\Access97\Office\MSACCESS.EXE /wrkgrp \\TTTTT1\netcount\msacc\development.mdw /user developer


and here is another one:

C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" /wrkgrp \\TTTTTT\netcount\msacc\development.mdw /user developer


looks like your wrkgrp slash is wrong way .....

/wrkgrp.........

 

[CBragg]

You might also need a /excl just before your /wrkgrp

Otherwise what gregg says will work. Failing that take all the " " out, i know ive had trouble with them in the past.

 

[Karen Dawson]

Thanks guys for the help.

But I still can't get it to work, the first thing I did was change from \wrkgrp to /wrkgrp as this was a typing error, unfortunatley I still get the orginal error and now a second one saying if can't find "C:\Program Files etc.

I have also tried the other suggestions with no success.

I you are all out of ideas with this, what I am actually trying to do is open a database on the network with a specific workgroup.

I can't find a way of forcing the database to find the workgroup and use it before opening.

All help appreciated.

Thanks

 

[CBragg]

Im asuming that your using a local version of Access yet the workgroup file and database are stored on the server??

If this is the case, have you logged onto the domain?? It might not be able to see a part of the shortcut, just double check to see if all your folders are correctly spelled etc.

Here's one of mine, otherwise i cant see why your shortcut shouldnt work.

M:\Program Files\Microsoft Office\office\msaccess.exe Q:\Data\Income.mdb /excl /wrkgrp Q:\accessdata\system\system.mdw

Hope this is of benefit.

 

[ghudson]

This is how I would set your Target: field...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "N:\Transfer\Karen\CLIENT DATABASES.mdw" "N:\Transfer\Karen\WorkingDatabaseVer2.mdb"

Is your msaccess.exe program file located @ "C:\Program Files\Microsoft Office\Office\msaccess.exe" ???

I also noticed that you had an extra " after the /wrkgrp

Here is sample of how I use the shortcut for a secured db using runtime and a user group...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /runtime /wrkgrp "X:\Databases\dbSecured.mdw" "X:\Databases\TestDB.mdb" /user TestUser

HTH

 

[RichMorrison]

If your paths contain spaces then
YOU MUST use quotes around the path.

Otherwise, the example from cbragg looks OK.

RichM

 

[Karen Dawson]

Hooray

Thanks ghudson I copied the path you wrote for me and this works.

Just have to find out the paths on Head Office network and do the same.

Thanks again I would be lost without this forum and all the helpful people answering the questions.

Karen