----------
> From: Steve Grose <[log in to unmask]>
> To: [log in to unmask]
> Subject: Update with odbc?
> Date: Tuesday, May 13, 1997 1:52 PM
>
> Has anyone successfully updated an Image database via ODBC. I'm using
> Visual Basic and Access.
>
> I know the JET engine requires a unique primary key, but I was thinking
of
> using the sqlpassthough. If my understanding of this parameter is
correct
> JET does not inspect this parameter for correctness. It just passes it
onto
> image to be performed. Once the SQL Update command was at the Image SQL
> end.  Image would execute it, not caring about indexes. I hope.
>

Steve,

If you're using PC/API from HP --- don't.  The updates are unreliable
(which is why they are coming out with ODBCLink/SE - which is very
reliable.

If you want to continue using it however, yes, there must be a unique
primary key, and Access is not the best tool for the job either --- stick
with VB, and use 4.0 (16-bit) for better results --- 3.0 is really
unreliable.

Your best bet is to wait for ODBCLink/SE to come out, or check out my
article in this month's Interact for the phone numbers of the third party
vendors who offer ODBC, if you really can't wait and need it going now.

Joe
---------------------------------------------------------------------------

-
Joe Geiser - CSI Business Solutions, LLC
140 Bristol-Oxford Valley Road, Suite 102
Langhorne, PA  19047-3083, USA
Phone: (215) 945-8100     Fax: (215) 943-8408
[log in to unmask]            http://www.csillc.com
---------------------------------------------------------------------------

-