Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is,
identify which workstations are failing and compare MDAC versions against
those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC
as appropriate. In any case, be sure to refresh all the link tables in MS
Access. If some workstations still fail, delete the link tables in MS
Access and set up link tables again.
I hope this helps...
Pat...
[EMAIL PROTECTED]
----- Original Message -----
From: "John Jensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 1:55 PM
Subject: Re: write problems via MS Access 97 in table with timestamp and
primary key
> I used to get this all the time, myself, when I was trying to update
> a mysql database with Access 2000 through myodbc. Funny, at the time,
> nobody else seemed to understand what I was talking about. Once I got
> phpMyAdmin working, the problem became academic, but it never did get
> solved.
>
> I'm still trying to find a solution to my $FORMATQUERY ORDER BY
> problem with a logic function on two values. Baring a solution, I can
> only hope for a workaround before a year of effort is not wasted,
> because someone else beat me to market. Please, this does not need to
> be a volunteer effort. If anyone thinks they can solve this, contact
> me directly and we can work something out.
>
>
> On 24 Jan 2001, at 6:34, Bob Hall wrote:
>
> > >One of our users is getting the message "another user has changed
> > >this database......etc save changes to clipboard or drop changes...
> > >etc", when he tries to update certain fields in the table. The table
> > >has a timestamp and a primary key. In fact, this user can change
> > >certain fileds without difficulty for certain types of data and not
> > >for others (i.e. Access accepts changes when the data is a document
> > >but not when its a collection). To make things more confusing.,
> > >other users can change all fields in the same table via Access
> > >without receiving the error message. Any one else had and solved
> > >this problem?
> > >
> > >Susan Albright
> >
> > Ma'am, this is an ODBC problem, not a MySQL problem. I assume that the
> > table is a linked table in Access. How is it accessed? Directly,
> > through a query, or through a form? Are there any joins? Does the
> > problem occur only through a query or form that joins the table with
> > another table? What do you mean by 'the data is a document' and 'its a
> > collection'? These aren't MySQL or Jet datatypes. What is the user
> > who's having problems doing that the other users aren't doing?
> >
> > Things that people have done to solve this include dropping and
> > adding primary keys and timestamp fields, setting up relationships
> > between tables as much as possible (you can set up a relationship
> > between linked tables, but I don't think you can specify what the
> > relationship is), and selecting UniqueRecords in queries (DISTINCTROW
> > in SQL).
> >
> > Bob Hall
> >
> > Know thyself? Absurd direction!
> > Bubbles bear no introspection. -Khushhal Khan Khatak
> >
> > ---------------------------------------------------------------------
> > 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
> >
>
>
> 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
