John Bodin
jbodin at sbor.com
Fri Oct 3 11:23:16 CDT 2014
If you get a workbook or doc from the internet or attachment in email or a cd for instance, when you save it your computer you need to right-click and hit properties on the file. If you get a button on the bottom that says "Unblock" and a description about why this file is blocked, then this could be the issue. They have been using this file for some time so it's doubtful, but easy to check. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, October 03, 2014 12:14 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Excel Linked Table - "Sharing" Problem John, The Test Excel file and the Production Excel file are both in the same folder. Trust settings are set up properly. I am not familiar with the Excel Block flag. Where is this located? Thanks, Brad PS. My best guess is that Access doesn't like the Production Excel file because it is a complex spreadsheet. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bodin Sent: Friday, October 03, 2014 9:34 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Excel Linked Table - "Sharing" Problem 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 -- 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