Sytze, If you are using ACT V6 up to ACT 2000 then the databases were certainly dbf files but generated using Codebase. In certain circumstances I think Codebase removed the 254 field limit in a table hence becoming non standard and I think they actually name tables as .dat files if I'm not mistaken.
Also the fields are simply numbered such as "Field_1", "Field_2" etc as they use an internal data dictionary for user defined fields - yet another problem! The indexes certainly are non standard so you can't do anything with them which could cause problems when finding information as a lot of it is pseudo encrypted. I only did data transfer one way ACT into VFP and did this using the export feature which is really quirky. However if you want to go the other way (which is what I assume) then you may need to go onto the Codebase site and see if they have an SDK. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: 22 August 2007 06:09 To: [email protected] Subject: VFP(9) to ACT! I need to run a VFP app and connect to a ACT! database to sync client information. Is there anyone here who is familiar with this program ? At one time, I thought ACT! was based on dbf formats and I opened my big mouth and announced at a meeting that I could access the data.......... Please help me out of the hole ! Sytze [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
