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 |
+-------------------------------------------------------------+
