Re: Interfacing with a database using an API (i think...)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Gary,

The first question I would ask is, is there any overpowering reason you must
use this database product?

After reviewing the PDF in the SDK, and visiting their web site, I am
strongly impressed that this is a poor database solution for any company
that is looking at an extensible or scalable framework for their future.
This product does not have any OLE DB or ODBC drivers, and in fact, the
documentation discourages anyone from trying to obtain or use any such
products with it. You can't even read the Help documentation online without
an account. They make only ONE product for allowing their database product
to interact with any other type of database product, and it only interacts
with Microsoft Access, and only in one direction. That product costs more
than twice as much as the database product.

It is the sort of product which may seem to be "cheap" (inexpensive) in the
short run, but the hidden costs associated with upgrading, in terms of
extensibility and scalability, which involve buying more and more
proprietary software from the company, or buying support from the company,
and/or the cost of paying a programmer for the incredible number of hours
needed to write a custom proprietary application to interact with the
database, make it a cost nightmare in the long run.

In other words, this is the sort of tar baby that very small companies,
headed by technologically ignorant people, innocently buy, thinking that
they are saving money. Eventually, assuming that the company which is using
this software prospers, it *will* have to be abandoned in favor of some real
professional, scalable, extensible product, and the longer they put it off,
the more it will cost.

If you work for this company, you have my sympathies. If you do not work for
this company, but are an independent contractor, my advice would be to
recommend a change in products, and if that recommendation is not heeded,
run, do not walk, to the nearest exit.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer

Presuming that God is "only an idea" -
Ideas exist.
Therefore, God exists.

<garyusenet@xxxxxxxxx> wrote in message
news:1142940044.576611.197630@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
At least I think it's using an API (i don't totally understand the
concept.)

I'm using Act 6. I need to interface with the act database and add
'contacts' to the database. The reason I need to do this is because i'm

writing a little program to add a new prospect to the database when a
telephone lead rings through, the receptionist will use this program,
enter a few pieces of information and then transfer the call to the
salesman - at which point the salesman can pick up the new contact in
the Act program. This should be fairly straightforward.


I'm stuck. I cant figure out how to connect to the database. Or how to
add contacts to it. There is an extensive SDK pack which shows you how
to do this but i've had no joy (partly because the examples are in c++
and i use c# (i've only been learning it over the past couple of
months.)


PLEASE can you take a look www.strident.net/act i've included all the
files and the SDK. And can you then please offer any advice you can on
how I can do this.


So far i've managed to get access to the act namespace, but thats about

it - i can't figure out how to use it. (I got access by running tlbimp
on a .tlb file and referenceing the .dll this created - all of this has

been a very steep learning curve for me!)


I'd really appreciate your effort, i'm totally stumped at the moment.


I just need to


(a) connect to a database.
(b) write / edit it.


Thanks for your time, and do please take a look / offer any advice you
can.


Gary.



.

Relevant Pages

  • Re: Interfacing with act database using API (i think)
    ... Please refer to the SDK docs on those type libraries. ... My guess is what you should try first is using the tlbimp.exe tool to create interop assemblies for the TLB files supplied in Act SDK and then figuring out from the SDK docs what is the right way to use the COM automation interface. ... I need to interface with the act database and add ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Having difficulty refactoring a DB application
    ... > I have a sensible database definition that more or less works for the ... OO is all about minimizing cost of certain future changes. ... the adapter itself - for example ensuring that the middle layer does ...
    (comp.object)
  • RE: .NET equivalent commands in Access VBA
    ... The true cost of software is not the cost to build it, ... the database is already split in that some of the data I read is ... I think I can call a command prompt from within Access so I ... Can I use .NET commands in Access? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiplicity, Change and MV
    ... and SQL Server were making enough gains in tackling some of the ... seeing significant cost savings when they use products such as U2 from ... reading the database (unless they suffer the cost of the SQL-MV ... "upgrade" to a SQL DBMS to get the missing features, ...
    (comp.databases.theory)
  • RE: Subtotal for a record
    ... I have made all changes to a backup of my original database so ... SELECT SerialNumber, PartNumber1 as PartNumber, Cost1 as Cost ... when I changed my data entry form to have all three ...
    (microsoft.public.access.reports)