John Bodin
jbodin at sbor.com
Fri Oct 3 09:33:30 CDT 2014
Hi Brad, Few things you probably already checked, but...: Did you put the Test file in the same H:\ location? (Assuming test file worked fine) Network permissions in that folder? Trustworthy Computing - are you trusting Network locations, specifically H: ? Excel Production file doesn't have the Block flag on it (that's bitten me a few times.) Good luck. John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, October 03, 2014 10:21 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Excel Linked Table - "Sharing" Problem All, Thanks to everyone who shared their ideas and insights on this issue. I started by experimenting with a test Excel file in order to try a couple different approaches. Then I tried to use the actual Production Excel file. When I try to import or link to this file, I receive this message. "The wizard is unable to access info in the file H:\Production.xls. Please check that the file exists and is in the correct format" Evidently, there is something in the Production Excel file that Access does not like. I need to get past this hurdle before I move forward. When time permits, I might experiment with VBA and Windows Automation to get at the Excel file data from Access. Thanks again for your help. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Friday, October 03, 2014 8:27 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Excel Linked Table - "Sharing" Problem There is a Boolean "MaintainConnection" property which may be related to this. >From what I understand, it's not available via the GUI......only VBA. > > Sure... There are many ways of doing this. But the key is to 'unlink' > the live connection between Excel and Access. > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com