Re: Problems using MyODBC, Access2k on linked tables

[Patrick Sherrill]

Chris,

Please ensure your table has a TIMESTAMP(14) and a unique key in the schema.
This should correct the problem.

I hope this helps.

Pat...
patrick@stripped

----- Original Message -----
From: Boget, Chris <chris@stripped>
To: <myodbc@stripped>
Sent: Wednesday, March 08, 2000 10:53 AM
Subject: Problems using MyODBC, Access2k on linked tables


> I'm using MSAccess2k, via the mySQL odbc driver, to access
> tables on our *nix server as linked tables.
> Whenever I try to modify any record, I get the following error:
>
> "This record has been changed by another user since you started
> editing it.  If you save the record, you will overwrite changes the
> other user made.
>
> Copying the changes to the clipboard will let you look at the
> values the other user entered, then paste your changes back
> in if you decide to make the changes."
>
> The only buttons available to me, of the 3 that are displayed
> are: "Copy to Clipboard" and "Drop Changes".  I do not
> have the option to "Save Record".
>
> Now, I am the *only* person modifying these tables as I am
> the only person in charge of this data.  No user inside our network
> is modifying it and no user from the web has access to it.  I can
> open up the table and immediately do something to the record
> and still I get the error.  I've tried everything that I can think of
> and I can't get around this.  I don't see any option that will allow
> me to open up the (linked) table in a single user/locked mode or
> anything.  This is becoming increasingly frustrating as I have to
> make all modifications (even complicated ones) via an update
> query from the mysql command line.
>
> Please, someone, tell me how I can make it so that this no
> longer occurs.  I've downloaded the last MS Jet/DB engine
> files, the latest MyODBC driver, the latest Access2k
>
> Thank you so much!!
>
> Christoph
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread1298@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
>
>