Access Form can't edit MYSQL fields

[Hmanvel]

I am using access 2000 as a front end to a MYSQL database. The main customer form will not allow edits. Other forms as well as subforms to this main customer form, DO allow edits. I have all settings in the main customer form design set appropriately, (allow edits "yes" etc.) but no joy. What's odd is that I can go directly to the linked table that the form is based upon, in access, and edit the fields there with no problem. This is a remote database on a web server, reached using ODBC connector. Any ideas?

 

[Hap007]

Hi Mmanvel,

I may be able to help.

Question for you, what version of the ODBC Connector are you using? or Where did you get the ODBC Connector?

Is the main form using a query to just one table, or a combination(group) of tables?

Open the query in Access, open the properties window,
Now, check the Recordset Type:

If the type is:
Dynaset
then try and change to:
Dynaset (Inconsistent Updates)

Let Me Know,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Hmanvel]

Hap, thanks for the feedback - 1) I am using MySQL ODBC 3.51, got it online (forget where, it was a while ago). 2) It is a select query of a single table 3)Inconsistent updates - funny you should suggest that, as right after I posted the original message I found a help file that also mentioned it. Tried changing to inconsistent updates, and no joy, same problem. HM.

 

[Hap007]

Hi Mmanvel,

Here is something else to try.

Open the query that you are using for the form and see if you can edit any of the fields in the query?

I have also seen problems like this when you create the link to the remote table and you do not correctly Identify the 'Unique' key(s) in the linked table.

You can deleted the link and try to re-create the link
or
You can make sure that the table has a unique key defined.

Hap...


Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[ProgramError]

if using mysql you will need a unique key for every table on the backend, relink and this will set the key in access.

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.