Willy Gielen writes:
Hi Willy and Barry,
Can you both please do a mysqldump from the table(s) you have problems
with? Also please include the version number of MyODBC and MySQL you
are using. Please don't take the data away, if possible.
Willy, make sure you have a timestamp column in the table and a
primary key field. See the MyODBC README, if you haven't read it.
Make sure the timestamp field is type (14).
To both:
If doesn't work:
- Change any date fields to datetime.
If still doesn't work:
- Try changing any 'float' types to 'double'. Might help and you won't
lose any data.
And doesn't work:
- Change any blobs to text fields.
Still wall ahead:
- Add an auto_increment field to table, if you don't have one.
Regards,
- Jani
Ps. The Access' error messages 'Write conflict' and 'Another user
has modified the date' or 'table opened by another user' are all
information less. It simply means that Access doesn't know, if
such thing has happened and is guessing things.
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
> Hi Jani,
>
> I seem to have the same problem on my W98 MySql Installation. I can
> create a record with Access97, but when I immediately afterwards try to
> modify it, I get the same error code that Barry got. I am sure that no
> other users are accessing my machine.
>
> Any ideas?
>
> Thanks,
>
> Willy
>
> Quintessence Consulting GmbH, Willy Gielen - wgielen@stripped
> Kopernikusstrasse 26, 30853 Langenhagen
> Tel. +49 (511) 7245 666 - Fax: +49 (511) 7245 667
>
>
> -----Original Message-----
> From: Jani Tolonen [mailto:jani@stripped]
> Sent: Montag, 4. Oktober 1999 12:40
> To: barry
> Cc: mysql@stripped
> Subject: MS Access 97 connection to MySQL
>
>
> barry writes:
> > I installed the MySQL server in the Linux Box and
> > use Win95 to connect through the MyODBC driver.
> > I can use MS Access 97 to add NEW rows into the tables in
> > a MySQL database but I can't update/delete.
> > MS Access 97 prompt an error that other user is using the
> > database but in fact I am the only user using it.
> > I have already define the primary key and add a timestamp field in
> the
> > database.
> >
> > rgds
> > Barry
>
> Hi Barry,
>
> Please check if you have other threads open in the Linux box
> that use the same database as you are using from Access.
>
> Please do mysqladmin proc in the Linux machine to verify
> what is happening with MySQL.
>
> Regards,
>
> - Jani
>
> --
> +-------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
> | /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +-------------------------------------------------------------+
>
