[AccessD] Excel Linked Table - "Sharing" Problem

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



More information about the AccessD mailing list