Opening DB from Word 1

[Gojira999]

Hi all! My first post!

Our office procedures guide is based on an indexed MS Word document with various hyperlinks. I have independently of this guide, created an MS Access db with related info.

I have been asked to insert a link in the procedures guide that allows users to view the DB. Simple enough, except the users don't have full Access just a run time version. When they try to open the link they predictably get an error message.

Do any of you know any way around this problem? Thanks

 

[mrMika]

is the run time MS Access app the one that you are trying to open or are you opening up a different Access database?

 

[Gojira999]

I am trying to open the DB using the runtime version of Access as a view facility.

We have done so previously using desktop shortcuts with a path like: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /runtime "Z:database\mydatabase.mdb", having started the shortcutin accrun.

Hope this clarifies!

 

[mrMika]

is the runtime located on the computer that you are working on? If so what is the shotcut path to it? If it is not located locally I don't see how it would run but if it is then I'm thinking that it should.

 

[Gojira999]

The individual users all have the runtime stored locally in an identically named directory. My own machine defaults to the full version I have installed.

I guess what I must need is a line of VB that replicates the shortcut action (substituting the DB).

Thanks for the quick responses by the way

 

[mrMika]

Perhaps creating a macro with a "Shell" command to open it up might work?

 

[Gojira999]

Will give it a try (once I have figured out how to use it!.
Many thanks.

 

[Gojira999]

Unfortunately, building macros in Word does not appear as simple as in Access!!!!

Could anyone be kind enough to walk an idiot (i.e. me)through the above solution?

Thanks

 

[PHV]

Unfortunately, building macros in Word does not appear as simple as in Access
Have tried to play with the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Gojira999]

I have (finally!) revisited this element of the project.

I have built a shell command that opens MS Access locally but I require it to open the run time version & a networked database.

Here is the code I have used - please can you let me know if you can spot any obvious flaws in my logic!

Thanks.

Dim var1
var1 = Shell(("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"/runtime "W:\dbfolder\dbname.mdb", 1)

 

[PHV]

Replace this:
var1 = Shell(("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"/runtime "W:\dbfolder\dbname.mdb", 1)
By this:
var1 = Shell("""C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"" /runtime ""W:\dbfolder\dbname.mdb""", 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Gojira999]

Thanks. Works a treat!