Access file does not work on different Machine

[Chris66]

I hate to bother everyone but, I am having a reoccurring problem with an Access program. I have two tables linked to Access, table one is created from an existing Excel file, table two is created from a Showcase Query. On my computer (Leb029) I can run the query from showcase, open the file and access works fine. However, when I open the access program on another computer (Lebanon-QRE1) and run the Showcase Strategy Query, the access program does not recognize the field names and starts prompting the user for parameters. Once this happens, the access file will not work on any machine. Now, if I run the showcase file on my computer then go to the QRE1 computer and open the Excel files, the access program works just fine. This is leading me to believe that Showcase Strategy is the "culprit". I checked all the versions of Excel and Showcase and they all appear to be the same. Would anyone have an idea of what might be causing this. Both computers are using ShowCase 4.00.040.204.

 

[John Steven]

Hi Chris66,

Are all the computers accessing the Excel files from the same location. Since you are linking, the doc's you are linking to have to follow the same file path. If you are linking from your machine to a file path on your machine then your users will not be able to follow that same path.
Make sure your file path is the same for your users as it is for you...
At least that's what it sounds like to me...
Hope this helps...

 

[Chris66]

Yes they are both accessing the Excel tables from the same location. I have the excel files in a public drive which all Machines in this plant can access.