BlueGazoo
July 11th, 2003, 11:06 AM
Im opening a Query to update. It works in the Access database, but not MySQL - im assuming because the proper relationships have been set in Access and not MySQL.
Im getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x8000FFFF)
Query cannot be updated because the FROM clause is not a single simple table name.
Is it possible to update tables from a Query if relationships are set, in MySQL?
How to set relationships in MySQL?
thanks in advance
Im getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x8000FFFF)
Query cannot be updated because the FROM clause is not a single simple table name.
Is it possible to update tables from a Query if relationships are set, in MySQL?
How to set relationships in MySQL?
thanks in advance