MS Access using free form FoxPro

[Guest_imported]

The company that I am working with has an existing software package called Mail Order Manager(MOM) which uses FoxPro backend. The company has been using MS Access for some time to create custom reports, as well as programatically manage processes not covered by MOM.

A consultant has advised the company IT staff that linking the tables to access will corrupt the FoxPro indexes, does anyone know where I could find some documentation to confirm or deny this claim?

I still can not figure out how an ODBC connection to a read-only table could "over-write FoxPro indexes with MS Access indexing logic".

 

[smedvid]

Having worked with FoxBase, FoxPro-DOS, FoxPro-Windows and Visual FoxPro (until Ver 5.0), I can say I've never seen corrupting resulting from linking to the database tables from MS Access. While, it may be possible (depending upon the version of FoxPro, I find it highly unlikely you will corrupt FoxPro if all you are doing is executing a data extract, SQL Select statement. You can check the MSDN/MS Knowledgebase for information. Also, drop a note on the FoxPro forum of this site. htwh, Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[smeadows]

Hi
I have tried similar - and yes it can cause corruption!, but you should be able to do it . I first copied the db to a test system, and sometimes things were fine but sometimes not and I am not sure why. I did not persue this very far as I could not risk damage to the "live" db,and did not have the time to spare, but I am sure it can work. (we paid the software writers to make changes.

Good luck

Steve