locked
How To Connect to linked table in MS Access RRS feed

  • 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>

    Monday, April 25, 2011 6:32 AM

Answers

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 26, 2011 9:42 PM

All replies

  • 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?

    Monday, April 25, 2011 3:28 PM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 26, 2011 9:42 PM