At 11:44 PM 1999-10-04 +0800, Jani Tolonen wrote:
>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.
[barry@venus barry]$ mysqladmin processlist
+----+-------+-----------+--------+-----------+------+-------+------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+--------+-----------+------+-------+------+
| 10 | barry | | barry1 | Sleep | 6 | | |
| 11 | barry | localhost | | Processes | 0 | | |
+----+-------+-----------+--------+-----------+------+-------+------+
The above show the processlist when MS Access Mysql database
Any idea.
rgds
