RE: MyODBC-3.51.03 + Access 2000

Good morning!

I am about to test wether we could "transfer" our Access 2000 data to =
MySQL.
MyODBC version 2.5 could not be installed, with release 3.51.03 =
everything
was fine except for one problem:

How-To-Repeat: After adding a new record in Access and navigating back =
and
forth, the added record displays #deleted# instead of the data added.

Workaround (but not useful in production environment): Close the table
(form) and reopen it. The data is then displayed correctly.

We are working on Windows 2000 Professional.

Please advise. Thank you.

Kind regards,
Bertrand Gillert
Geschäftsführer/Managing Director * Senior Translator
Locasoft GmbH * Localization & Translation Services
Postfach 20 08 45 * D-53138 Bonn
(Theaterplatz 1 * D-53177 Bonn)
Phone +49 228 3 86 70 84 * Fax +49 228 3 86 71 35
http://www.locasoft.com
Reg.-Ger. Bonn HRB 8326=20

------------------------------------------------------------ ---------
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 bugs-thread12175@lists.mysql.com
To unsubscribe, e-mail

RE: MyODBC-3.51.03 + Access 2000

Bertrand Gillert (Locasoft) writes:
> Good morning!
>=20
> I am about to test wether we could "transfer" our Access 2000 data to=
MySQL.
> MyODBC version 2.5 could not be installed, with release 3.51.03 every=
thing
> was fine except for one problem:
>=20
> How-To-Repeat: After adding a new record in Access and navigating bac=
k and
> forth, the added record displays #deleted# instead of the data added.=

>=20
> Workaround (but not useful in production environment): Close the tabl=
e
> (form) and reopen it. The data is then displayed correctly.
>=20
> We are working on Windows 2000 Professional.
>=20
> Please advise. Thank you.
>=20
> Kind regards,
> Bertrand Gillert
> Geschäftsführer/Managing Director * Senior Translator
> Locasoft GmbH * Localization & Translation Services
> Postfach 20 08 45 * D-53138 Bonn
> (Theaterplatz 1 * D-53177 Bonn)
> Phone +49 228 3 86 70 84 * Fax +49 228 3 86 71 35
> http://www.locasoft.com
> Reg.-Ger. Bonn HRB 8326=20

Hi!

Have you tried changing a cursor type ??

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
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 bugs-thread12176@lists.mysql.com
To unsubscribe, e-mail

Re: MyODBC-3.51.03 + Access 2000

Add a TimeStamp column to every table in your db. Then this goes away.

Arthur

----- Original Message -----
From: "Bertrand Gillert (Locasoft)"
To: "Bertrand Gillert (Locasoft)" ;

Sent: Thursday, July 11, 2002 8:55 AM
Subject: RE: MyODBC-3.51.03 + Access 2000


Good morning!

I am about to test wether we could "transfer" our Access 2000 data to MySQL.
MyODBC version 2.5 could not be installed, with release 3.51.03 everything
was fine except for one problem:

How-To-Repeat: After adding a new record in Access and navigating back and
forth, the added record displays #deleted# instead of the data added.

Workaround (but not useful in production environment): Close the table
(form) and reopen it. The data is then displayed correctly.

We are working on Windows 2000 Professional.

Please advise. Thank you.

Kind regards,
Bertrand Gillert
Geschäftsführer/Managing Director * Senior Translator
Locasoft GmbH * Localization & Translation Services
Postfach 20 08 45 * D-53138 Bonn
(Theaterplatz 1 * D-53177 Bonn)
Phone +49 228 3 86 70 84 * Fax +49 228 3 86 71 35
http://www.locasoft.com
Reg.-Ger. Bonn HRB 8326

------------------------------------------------------------ ---------
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 bugs-thread12175@lists.mysql.com
To unsubscribe, e-mail



------------------------------------------------------------ ---------
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 bugs-thread12177@lists.mysql.com
To unsubscribe, e-mail

RE: MyODBC-3.51.03 + Access 2000

> -----Original Message-----
> From: Bertrand Gillert (Locasoft) [mailto:BertG@locasoft.com]
> Sent: Thursday, July 11, 2002 6:26 PM
> To: Bertrand Gillert (Locasoft); 'bugs@lists.mysql.com'
> Subject: RE: MyODBC-3.51.03 + Access 2000
>
>
> Good morning!
>
> I am about to test wether we could "transfer" our Access 2000
> data to MySQL.
> MyODBC version 2.5 could not be installed, with release
> 3.51.03 everything
> was fine except for one problem:
>
> How-To-Repeat: After adding a new record in Access and
> navigating back and
> forth, the added record displays #deleted# instead of the data added.
>
> Workaround (but not useful in production environment): Close the table
> (form) and reopen it. The data is then displayed correctly.
>
> We are working on Windows 2000 Professional.
>

Check http://www.mysql.com/products/myodbc/faq.html#DELETED_proble m

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com



------------------------------------------------------------ ---------
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 bugs-thread12180@lists.mysql.com
To unsubscribe, e-mail