RE: MS Access 97 connection to MySQL

[Willy Gielen]

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. [phone] - Fax: [phone]


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

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
posting. To request this thread, e-mail
mysql-thread15039@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 mysql-unsubscribe@stripped instead.