Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Automation _ Linked Data In Excel, Without Access

Posted by: redpenner Jul 5 2019, 11:19 AM

I have a split Access 2010 database where the BE is on my own PC and each staff member has a local FE, but there is also a FE on the local network for use in mail merges, linked Excel spreadsheets, etc. that anyone can use.

I've just learned that many of our staff will be losing Access in a couple of weeks. We are moving to Office 365 and "only those who really need it" (per management) will still have the Access program, and by their definition that means only me. shrug.gif

When those staff open a linked spreadsheet or mail merge document, which is pulling data from the BE via the network FE, will they see the data or some kind of "data unavailable" message? Are there any other problems I can expect when this happens? (I already know my pivot tables are going away cryhard.gif )

Posted by: theDBguy Jul 5 2019, 11:31 AM

Hi. Just a guess, but if the Word document is linked to an Access database, and it's not available, then I would expect the merge to fail. If it's possible to link the Word document directly to Excel, then you might consider doing that. Is there any reason why you're using Access for the mail merge if the data is coming from Excel anyway?

Posted by: redpenner Jul 5 2019, 12:02 PM

The data is in Access, but I had a "Merges" FE with a query linked into an Excel sheet on the network, then the Excel sheet as the source for the Mail Merges.

I had a really good reason for this at the time that I can't really articulate right now, but maybe related to the fact that all staff FE's were originally on the network instead of on staff hard drives (and yes, that turned out really badly). Also I was using the spreadsheet for other things besides the mail merge.

Thanks for the info!