I have a major problem. I have an application that was created in Fox Pro and all of the records are saved in a file type of "dbf". I need to run some queries on the data on a monthly basis to create various reports for the unit I support. The vendor of the application will not make the needed changes for us because there are too many other company's using the product and it would be possibly extra work for them that the others wouldn't want or need. This is what they have told me at this point in time.
The problem is I believe the "dbf" files are protected so I can't Import or Link to them through Access at this point since I receive error messages when I attempt too using Access. Is there a way around this problem I am having?
I have used Access to link to Fox Pro tables in a third party application without any problem. If the vendor has applied some form of protection, you're stuffed, really. Have you asked them if they can provide ODBC connectivity?
Thank you for your help. I found that there was a Fox Pro driver I had not used. Once I used it I was allowed to create an ODBC connection to the database tables.
I can now run my queries and create the reports my users need.