Hi Dave, thanks for that It is in fact ACT! Version 9 and I think data is in a PAD file It seems a hopeless task Version 9 won't even import it's own ACT! Version 6 or 7 files Sytze
On 8/22/07, Dave Crozier <[EMAIL PROTECTED]> wrote: > 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.
