Referencing Word Object library from Access

cornholme
cornholme used Ask the Experts™
on
Hi All
I have an Access 2007 frontend running under Access 2016 runtime and it works just fine. Recently the backend was move to a google drive without any problems. Then the IT guy looking after the network decides to move Office Std 2007 to the google drive, I now have problems. The Word Object library is no longer available so the access mail merge routine within Access FE fails. The question is this how do I within vba Tools References point to the Word Object Library?

Or is there another way of referencing the above Word Object Library?

Regards
cornholme
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Recently the backend was move to a google drive without any problems.
I'm glad you haven't experienced any issues, but running any Access database over a WAN, which this is, is simply not a good plan.  I hope you have implemented a rock solid backup plan!  Access is designed to run solely over a Wired LAN, everything else is ill-advised.

Then the IT guy looking after the network decides to move Office Std 2007 to the google drive
I was unaware that Google has web versions of Office, One way or another, you cannot automate web versions of Office.  You have to have desktop versions of the application(s).  If it is merely a reference issue, but I doubt it based on your description, you could switch your code to use Late Binding and do away with needing to set any references at all.

Author

Commented:
Thank you  Daniel, I'll follow up on Late Binding idea.
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
Can you actually install Office on Google Drive? I didn't think that was possible ..

I second Daniel's comment regarding using Access on a WAN. You will find it unreliable, show, and very prone to corruption.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi Scott,
Thanks for the comments. A bit of background maybe.  I'm the tail trying to wag the dog here, and failed dismally. I wrote a multi-user(6) Access database with local FE's and server based BE about 10 years ago and its worked fine until 3 weeks ago when the client moved their office. Scrapped their server and move data storage to google drive. I played no part in this move. I became focus of attention last Monday with a call that "your database has failed". The IT guys had done real good job trashing the db during the migration to the new kit.  So one the jobs to do find how to refer to Word Object Library so the mail merge can be run. It appears that the simple solution is to reinstall Word on the local machines rather than refer to the google drive, which I've no knowledge of, and late binding I don't think will solve the issue. A Word Object Library reference is needed, which is presently absent

 You mentioned data corruption that little rascal has already paid a visit. That is another job!

So Daniel and Scott thank you for your help. Your comments have been very useful.

regards
cornholme
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Your primary concern should be moving the database back locally (within a wired LAN for standard setups).  Their IT guy obviously knows nothing of Access and this should be highlighted quite rapidly as this is jeopardizing their data!  This should be obvious by the simple fact the db worked for 10 years, up until the time it was migrated.  Then add to that the fact that automation is no longer functional... doesn't take a rocket scientist to figure out things need to be put back the way they are, or speak to someone (ie you) who know what setups can work with Access.

I hope you're charging by the hour on this one.
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
I'd approach the client with Daniel's suggestion - or perhaps suggest a rewrite to a web-based product at about 30X the cost of the Access system. That generally gets them to light up the IT guy pretty quick :)
Cheers guys for the Support! The idea of lighting up the IT guy is a really good suggestion.  I am charging by the hour and as its Xmas its time for a pay rise.  

The job is stopped presently waiting for the internal IT Guy.

Kind regards

cornholme

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial