Steve,

I use it primarily for reports because I have not been able to use it
consistently for updating without problems.  I have more than once had to
restart our 3000 because I was unable to abort a ODBC connection that failed
with some mysterious error.  This has happened  even while running reports.
 Wait for ODBCLink/SE.  MB Foster would have had to really work hard at
making it less stable than PC/API.

Glenn
 ---------------------------------------------------------------------------
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
 ---------------------------------------------------------------------------

 -