Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 09-17-2013, 07:39 PM
BobBridges's Avatar
BobBridges BobBridges is offline Excel to Access to Excel for report automation Windows 7 64bit Excel to Access to Excel for report automation Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Well, Access (like most database apps) is constructed to allow multiple users concurrent update. But I don't know of any other Office app that does that. It doesn't matter (AFAIK) that you're writing a VBA program to do it, because VBA is going to invoke Excel to do the actual updates—your VBA program is "calling" Excel—and Excel is going to complain, when you try to update a workbook, that someone else is currently using it. And likewise it doesn't matter that the request to update the workbook is coming from Access; the request still goes to Excel, and Excel still knows better than to let two people update a document at the same time. If you want true concurrent update, it has to happen in Access, to an Access database. And yeah, you can get Access to update the Excel workbook later, for reporting purposes; but only at a time when no other user happens to have it open.

Wait a minute, I just thought of something: You said other people, up to 12, may be using that workbook. But are they updating the workbook, or only reading it?

If they're only reading it, not changing anything, then they can open the workbook as Read-Only. Then Excel can update it. Would that work for you?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to Access to Excel for report automation Projects Cash Flow Report in Excel not creating monthly data gardwr Project 2 09-02-2013 09:10 AM
field controls for automation via excel ajetrumpet Word 0 07-13-2013 09:48 PM
Excel to Access to Excel for report automation Inexplicable automation errors in Word and Excel RichardP Word VBA 4 08-16-2012 07:38 PM
Automation Word-Excel stephen_pen Mail Merge 0 09-22-2011 05:17 PM
Excel to Access to Excel for report automation Word, Excel automation Paul-NYS Office 3 06-29-2011 01:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft