ACTFox

Using Microsoft FoxPro with ACT!

FoxPro is the best tool for working with ACT! because it is

• Fast - even on huge databases

• Can handle DBFs as well as Microsoft SQL databases

• Enables you to make direct edits in to the database

• Enables you to use all the functions in the SDK

• The language syntax is easy to learn and straight forward

• Enables you to make standalone EXEs as ACT! AddOns

• Microsoft FoxPro is relatively inexpensive - under $100

ACTFox is a FoxPro program which displays all the ACT! tables, and their relationships in windows to browse and edit

See all the tables at a glance

Learn about how ACT! works and the relationships between its tables

Make editing changes and correct problems (be careful)

Using Methods, Properties, and Functions from within FoxPro to control ACT!

Import data from other contact managers into ACT!

Click to enlarge

Contact - names, addresses, phone numbers, user defined fields  Sales - sales and opportunities  Rel_Grp - relation file into Groups  Group - categories of contacts  Email - Internet addresses for contacts  History - Cleared activities, Attachments and Notes  Rel_ACT - relation file into Activity table  Activity - Calls, meetings, and ToDo's

ACTFox.prg with Microsoft FoxPro, preferably Visual FoxPro.  

1. Get to the Command Window

2. CD or SET DEFAULT TO you ACT Database folder

3. DO ACTFOX

 
Using Microsoft FoxPro with ACT!

Microsoft FoxPro is an important tool for any ACT! Certified Consultant or database administrator.  It allows him to make changes directly and quickly to the database in ways that ACT! cannot.  It should be used with care, experience, and training.   The following articles are examples of how FoxPro can be used.