>>>>> "Michiel" == Michiel Kreutzer <M.T.Kreutzer@stripped>
Michiel> I have been trying to split a MS Access database into an access frontend
Michiel> and a mysql-backend on linux, linked by myODBC. So far most of
Michiel> functionality is there, but I still have some mayor problems:
Michiel> 1. sorting seems to be a problem. I have coverted some
Michiel> queries into pass-through-queries, manually typing the
Michiel> SQL statement, and that fixed the sorting problem. However,
Michiel> pass-through queries are not updatable, i think, so I can
Michiel> not add or delete from the sorted form.
Which Access version are you using? I thought that with Access >
Access 97 you should be able to use ORDER BY without any problem.
Michiel> 2. When I add a new record in a form containing a linked
Michiel> subform, the subform is empty. This is really annoying, and
Michiel> I have not been able to fix this in any way. When all was
Michiel> running under Access, I had no problems. This is the situation
Michiel> in short:
Michiel> In MySQL: three tables Customer, Order and Products
Michiel> These are linked into access.
Michiel> In Access: From the tables queries are defined, on for the
Michiel> form, containing fields from the Customer and Order
Michiel> tables. The query for the subform contains fields
Michiel> from Products, including an Order_ID to match the
Michiel> form and subform.
Michiel> When I open the form and click for a new record, the
Michiel> subform is empty, where it should be filled with a
Michiel> blank record (with only Order_Id filled in).
Michiel> Does anybody have an idea what causes this behavioour, and how it
Michiel> be solved?
I hope someone else can answer this one...