shortcut not using specified workgroup (97)

Topic

New Reply

I created a desktop shortcut to my mdb & specified a workgroup on the server it is to be opened with. But the logon box says I

Reply | Quote

Replies

Arage,

You have to add the access.exe part in your shortcut
“C:Program FilesMicrosoft OfficeOfficeMsAccess.exe” “H:dataSecure OACO.mdb” /wrkgroup s:/oaco/OACO.mdw
if MsAccess.exe is in this default directory, else change the path to where you have installed the MsAccess.exe.

Francois

Reply | Quote

thanks Francois that helped but I get the following error now.

What I did was to create a new shortcut & apply the command line criteria, somehow the /wrkgroup parameter is causing this error it says

Reply | Quote

Sorry, you may me
I was looking at the beginning of the command line and not to the end:

“C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE” “H:dataSecure OACO.mdb” /wrkgrp s:oacoOACO.mdw

The parameter is /wrkgrp and not /wrkgroup.

Francois

Reply | Quote

Francois,
I sure hope by your last post you meant that I should be typing /wrkgroup, not /wrkgrp. You know why? B/c my book (access2k) says type /wrkgroup!

But anyway, I tried /wrkgrp & it worked except now I get an error that the .mdw cannot be found in the path I specified, but it IS there in that location on the s: drive! Now what?

Reply | Quote

not really.
S:oaco is actually S:O A C O & I

Reply | Quote

Do you mean that there are space in your path ?
Then you have to enclose the path in quotes like in the first and second part.

“C:Program FilesMicrosoft OfficeOfficeMsAccess.exe” “H:dataSecure OACO.mdb” /wrkgroup “s:o a c oOACO.mdw”

Let’s have another try

Francois

Reply | Quote

temporary victory Francois your advice worked, but I

Reply | Quote

What a space can do!
Now we have solved a space problem, do you think we are member of NASA ?

To see what MDW file you are using, the only way I have found so far, is to open a module, go to the immediate window and type:
? dbengine.systemdb

Reply | Quote

Maybe
/wrkgroup s:oacoOACO.mdw
instead of
/wrkgroup s:/oaco/OACO.mdw

Francois

Reply | Quote