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!
Referencing Word Object library from Access
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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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 driveI 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.
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.
I second Daniel's comment regarding using Access on a WAN. You will find it unreliable, show, and very prone to corruption.
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
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
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.
I hope you're charging by the hour on this one.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial