I am using VFP 6.0 Database as a repository housing one table of current data. I have created several local views to present different aspects of the data to the users which they access through MSAccess linked tables using an ODBC connection. The problem I'm having is that when my users create Access Queries using these linked "tables" and they pull in only certain fields, the resulting recordset does not contain the data associated with the fields that they pulled. Instead, it seems to give them data in the order of the underlying local view.
Can someone explain to me why this happens or point me to a good source of explanation? And, is there a workaround without having to import the data into Access? - size limitations.
Thanks for your advice in advance
ERM
Can someone explain to me why this happens or point me to a good source of explanation? And, is there a workaround without having to import the data into Access? - size limitations.
Thanks for your advice in advance
ERM
