Dynamic Link to excel sheet

[4D3]

Hi,

I have a database, that is linked to a number of excel sheets, I need to make the queries run as long as the database and the excel sheets are in the same directory.

This is because different people need to use the database and posting it on a network is not possible.

When i try to run the query from a different computer i get a warning saying that the excel source cannot be found.

Is there a way to combat this?

 

[Mihail]

Split the database then distribute the FEs to the network computers.

 

[4D3]

Split the database then distribute the FEs to the network computers.

hi,

i have no idea what that means, please can you explain.

thanks

 

[Mihail]

Read HERE what I mean.