How To Connect to linked table in MS Access

Question

User1513962562 posted

im showing data in gridview from access database .

Problem is tables in mdb file are linked to some Visualfoxpro dbf files.Below How It look like ,it works in LocalServer but not in Remote Server.Any Ideas???????Error Comes As:  Server Error - CouldNot Execute Query Could Not Link To the Table

<

asp:AccessDataSource ID="AccessDataSource1" runat="Server" DataFile="~/PR2.mdb"

SelectCommand

="SELECT * FROM m1 WHERE idnumb = @idnumb">

 

<SelectParameters>

 

<asp:Parameter Name="idnumb" /> </SelectParameters>

 

</asp:AccessDataSource>

Answer 1

User-1199946673 posted

tables in mdb file are linked to some Visualfoxpro dbf files

That meand that the drivers need to be installed on the server. And are you sure that the path to the dbf files in the linked tables are OK?

Answer 2

User3866881 posted

Hi：）

Besides what hans_v said, have you confirmed that your VisualFoxPro's files' links are valid, Can your programm find them through these links?

Thx again