Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Connect to ACT! 2000 Database with Visual Studio

Posted on 2012-04-08
8
Medium Priority
?
400 Views
Last Modified: 2012-08-14
Hello--

Has anybody had any luck with connecting to a Act! 2000 a.k.a. Act! 5.0 database with Visual Studio 2005?

Thank you,

FtB
0
Comment
Question by:fritz_the_blank
  • 4
  • 4
8 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 37823724
Connect ... how?

Are you trying to read or write to the database? What are you attempting to achieve?
0
 
LVL 46

Author Comment

by:fritz_the_blank
ID: 37823971
I have a client who's using this older version of ACT! and will continue to do so. I hope to write some add-on scripts in VB.Net for particular functions specific to his needs. If he were running 10.1 or later, there would be a way to connect relatively easy (then it would be a SQL Server Database, and ACT! provides a means of easily connecting to it).

As it stands now, the database files are .dbf, and I think that they are visual fox pro files, but I don't know for certain.

The add ons that I need to script will require both reading and writing to the database.

Thank you for taking the time to read my question.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 37824091
If you need to read AND write ... you can only do this via the SDK. This would be the same in the new versions ... you can not write to the SQL directly, either

Not sure if the old SDK is still available for download, but I might have a copy, somewhere.

ACT! ACT! 2000, the DBF Is FoxPro ... but writing to it will damage the index files. Parts of the database use CodeBase IV and not FoxPro

What sort of scripting are you trying to do? Which tables are are wanting to read/write?
Maybe I could point you to an addon that already does it ... or to the best method
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 46

Author Comment

by:fritz_the_blank
ID: 37824119
I looked at the SDKs, bu they only go as far back as ACT!2005.

There are a number of items that he'd like me to rework including the alarms system, email integration, automation between ACT! and practices in his office. We've looked at the existing add ons and none meet our needs.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 37824184
Can you be a bit more specific about how you want them re-worked? I may know some more of the addons and methods than you can easily find...

Learning the old SDK isn't a trivial task ... you'd really want to NEED it before venturing down that path
0
 
LVL 46

Author Comment

by:fritz_the_blank
ID: 37824253
There are many items that he wants. Here is an example:

1) he finds a new employee that needs placing
2) he wants to generate personalized email messages to may possible employers
3) for each email sent, an should be added to follow up within a couple of days
4) any notes should be able to be cross referenced by both the prospective employer and employee
5) a reference to the path and name of documents related to the search be held in the notes field

Again, this is just one item of many that he's looking for. So, it really comes down to whether or not I can connect to the database.
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 2000 total points
ID: 37824597
Has he considered upgrading to a current version of ACT!?

Much of this is far easier in the new versions ... at attachments and notes that are linked to multiple contacts.

In ACT! 2000, using groups for the job vacency (or employer) is one way that we used to do that.

I'll have a look for my copy of the old 2000 SDK
0
 
LVL 46

Author Closing Comment

by:fritz_the_blank
ID: 37834757
We'll have to upgrade--I would prefer not working with the old .dbf files.

Thank you for your help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question