> In your OOo Form/Subform properties in the Data tab, do you specify a > Table, Query, or SQL as the content type? I think if you specify SQL, > and type or paste the actual MS Access query (with functions) into the > content box, then the query will be sent directly as a pass-through > query and interpreted by MS Access. >
I specify a table (which is a really a view). I have tried to paste the SQL but it didn't work. I have looked a bit more into it and it's the ODBC driver where the error message comes from in both cases, so I guess I'll have to forget about it because it's Microsoft who provides that driver. > The setup for the master/slave linking should use the names or aliases > derived from the form/subform queries to link the master field in the > form to the slave field in the subform. > > This all assuming that you're connecting via ODBC to MS Access, because > I don't think OOo can read MDB files directly yet. If you're reading the > MDB file directly somehow then this is not going to help. > Yes, I read the MDB file through ODBC. I'm not using forms because it's a Writer document, but thanks anyway. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
