I am trying to link MS Access and Mysql together using ODBC 2.50.24 for Win95

This is the Mysql table I'm trying to modify: +------------------+--------------+------+-----+---------+ | uid | int(11) | | PRI | 0 | auto_increment | | errormessage | varchar(100) | YES | | NULL | | | other | text | YES | | NULL | | | errorgiven | text | YES | | NULL | | | location | varchar(255) | YES | | NULL | | | comments | text | YES | | NULL | | | name | varchar(100) | YES | | NULL | | | username | varchar(50) | YES | | NULL | | | password | varchar(50) | YES | | NULL | | | email | varchar(150) | YES | | NULL | | | site | varchar(50) | YES | | NULL | | | os | varchar(50) | YES | | NULL | | | browser | varchar(50) | YES | | NULL | | | screenresolution | varchar(50) | YES | | NULL | | | screenspace | varchar(50) | YES | | NULL | | | colordepth | varchar(50) | YES | | NULL | | | cpu | varchar(50) | YES | | NULL | | | java | varchar(10) | YES | | NULL | | | jscriptversion | varchar(5) | YES | | NULL | | | member | varchar(25) | YES | | NULL | | | delegate | varchar(50) | YES | | NULL | | | subdate | varchar(25) | YES | | NULL | | | deldate | varchar(25) | YES | | NULL | | | responsedate | varchar(25) | YES | | NULL | | | status | varchar(50) | YES | | NULL | | | solution | text | YES | | NULL | | | techrep | varchar(50) | YES | | NULL | |

Now I can retrieve information no problem however when I attempt to edit anything I receive the error message "..couldn´t perform the edit because another user has changed the record..." (I'm the only user of MS Access and the database I'm using in Mysql is not online)

Mysql version 6.9 Dist. 3.21.33b for BSDi4.0 on i386.

After searching some newsgroups threads the most common cause of the problem was data fields using floating point numbers. As such I changed subdate,deldate and responsedate to VARCHAR as opposed to DATETIME as it was before. The error still arises though.

Does anyone have any helpful suggestions for me to break past this barrier?

Sincerely,