hyperlink to database using workgroup file

[teel73]

Is there anyone out there that can help me with this problem. I want to create a hyperlink in MS Outlook to my database file using my workgroup. The problem I'm having is when I put the following:

file://"N:\DbaseFiles\SCC_Dbase.mdb"

that works. It will open Access to that dbase file. But if I include the workgroup file associated like this:

file://"N:\DbaseFiles\SCC_Dbase.mdb" /WRKGRP "N:\DbaseFiles\CSS_Issues.mdw"

it doesn't work. Can someone please tell me why. I've been struggling with this for days now. I can't find any solutions.

 

[Moniker]

I'm not positive this will work, but have you tried encapsulating the whole thing in double-quotes and using single-quotes internally? This is what I mean:

file://"[COLOR="Red"]'[/COLOR]N:\DbaseFiles\SCC_Dbase.mdb[COLOR="red"]'[/COLOR] /WRKGRP [COLOR="red"]'[/COLOR]N:\DbaseFiles\CSS_Issues.mdw[COLOR="red"]'[/COLOR]"

Again, not positive that will work, but I'll bet the problem is that things after the close double-quotes are breaking the code.

 

[teel73]

thanks, but nope .. that didn't work either. This is mind boggling! Do you know of a way to do it in VBA? Maybe there's a way to tell Access what workgroup to use through VBA. I also tried using the command-line arguments on the Advanced tab under options in Access.