I need Word 97 to open specific Access97 file

[telephoto]

Hi

I don't mind if it's hyperlinked or by a command button and a macro...

I am trying to open a specific database with a click from a word document.

It's not too bad to open the Application, but I can't get the file to open as well.

Any ideas please

Telephoto

 

[DJS2]

Set up a mail-merge to the access database. When you open the word document it will automatically open the database and access the correct table.

 

[telephoto]

DJS2
Thanks - would it were so easy!

I have a document with hyperlinks to instructions, and we want to have a link pointing to a database. Either the hyperlink or a command button can open Access, but I want to open the .mdw as well.

Telephoto

 

[TonyJollans]

Hi telephote,

Am I missing something here? You have other hyperlinks - why should this one be different? Just Insert > Hyperlink... (or press <Ctrl><K>)) and type in (or browse for) the target db name.

Enjoy,
Tony

 

[telephoto]

Tony

The Word doc is a briefing/instruction document with links to business procedures. The one which is giving trouble is a database saved as an mdw, the shortcut path (abbreviated) looks like this:

&quot;C:\Program Filesmsaccess.exe&quot; &quot;Server\Path\SecReg.mdb&quot;/wrkgrp &quot;server\Path\Registry.mdw&quot;

Within VBA in Excel it is possible to start Access and open a specific file, using, for example:

Dim RetVal
RetVal = Shell(&quot;&quot;&quot;C:\Program Files\Microsoft Office\Office\MSACCESS.EXE&quot;&quot; &quot;&quot;\\ServerNo\PathTofolder\filename.mdb&quot;&quot;&quot;, 1)

Access will start and open the file.

I am trying to do this in Word, but the .mdw doesn't want to play. The furthest I can get is to open Access, but the punter looking for the file won't know where to start.

Does this explain the position better?


Telephoto