Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Connect to ACT! 2000 Database with Visual Studio
Posted on 2012-04-08
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
4
8 Comments
Connect ... how?
Are you trying to read or write to the database? What are you attempting to achieve?
Are you trying to read or write to the database? What are you attempting to achieve?
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.
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.
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
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
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.
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.
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
Learning the old SDK isn't a trivial task ... you'd really want to NEED it before venturing down that path
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.
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.
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
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
Featured Post
What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
So every once in a while at work I am asked to export data from one table and insert it into another on a different server. I hate doing this. There's so many different tables and data types. Some column data needs quoted and some doesn't. What …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 23 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.