Wow. What an interesting project Steve.
If the views are huge, then ODBC links would probably increase the size of your db and the queries might be considerably slower.
If I chose to do that I’d convert the queries to passthrough queries. I’d test one first to make sure that the connection string found the server.
Good luck with that.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, December 04, 2015 8:02 AM
To: MS Access Pros List
Subject: [MS_AccessPros] Part Question, part rant, part OT
I have recently inherited a PowerPoint file with 100+ shapes that have embedded Excel files that are linked to MS-SQL server views (yeah, I know ...)
There is a VBA procedure that is supposed to loop and and refresh these things. But the procedure keeps having unexplained issues: it can't find the server (it's there), commands to excel about backgroundquery=false run but don't change the property, variables don't hold values (I have a counter figuring I could start over at the last bad one, not at the beginning) ... Basically, it seems to me the Powerpoint VBA engine is a pile of dung; I can call any other program in the Suite from Access and not have anywhere near this amount of problems ...
Which leads to the question, should I just run the code from Access, calling PPT and Excel from our old friend (this all ver 2010 btw.)
thanks for letting me vent,
Steve Conklin
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar