John,
To avoid the issues you mentioned, each table requires an AUTO_INCREMENT
column and a TIMESTAMP(14) column.
We have been coding with VC++ and using various third party ODBC clients,
including MS Access, pretty much since the inception of MyODBC. When using
the Jet Database Engine (MS Access) the ability to recognize uniqueness of a
record/row is paramount. Adding the aforementioned columns assures
uniqueness.
Pat...
[EMAIL PROTECTED]
----- Original Message -----
From: "John Jensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 2:40 PM
Subject: Re: myODBC question
> Speaking as one who tried working with such a connection, FORGET IT.
> While entering data, I might get all or half a record entered when
> the message arrives telling me the information cannot be posted,
> because another user was editing that record (which I could tell was
> simply NOT the case), and I had the option of either dropping my
> input, or put the whole record in the past buffer. Occasionally, I
> would get lucky and get a whole record entered and saved, but mostly,
> my datbase was getting filled with gaps.
>
> Get phpMyAdmin. It is far more reliable solution.
>
> On 1 Feb 2001, at 12:06, (Mr) Pekka Gaiser wrote:
>
> > Hi there,
> > A DB newbie question - can I use MS Access for remote mySQL databases
> > using myODBC?? Thanks.
> >
>
>
> John Jensen
> 520 Goshawk Court
> Bakersfield, CA 93309
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
