Re: Access Front End Hassles

[Pascual Martínez]

Hi All,

I've recenty converty my Access 2000 database to use linked tables from a mysql server. It happens to me that some records seem to be locked. In the same table, there are few records I can not modify. When I try to write the changes it says that another user has modified the contents. I've tried to update the records from a form, from visual basic for applications code, directy from the table, creating a new database and linking the table with the same result. But with the Mysql Query Browser I can update the records correctly.

The data stored in the fields is the same that other fields so I think is not a record data type issue. The strange thing is that one record is blocked and the other not.

The access db is on a server and accesed through samba in a multiuser environment.

Hope this helps