Record Source (MySQL tables)

[bob120579]

Can you use an Access select query that has two MySQL tables joined as the record source for a form? I know that the tables work, but I am not sure because the query will not work as long as it has MySQL tables in it.

 

[PHV]

the query will not work as long as it has MySQL tables in it
Even with linked tables ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bob120579]

Yes. they are linked tables from MySQL. They are fully updateable from the Access Database even through action queries. But, it's just when I join them and use that select query as the record source, that it says the Record Set is not updateable.

 

[Golom]

It's possible that the query itself is not updatable ... regardless of the source of the tables it references.

Perhaps you could post the SQL and we can take a look at it.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[bob120579]

Ok, but I have it at home, so it will take a while. But what would make a query not updateable?

 

[Golom]

Outer joins, Joins without primary key fields, grouped queries, computed or constant fields, Aggregate functions, ... are some of the usual suspects for queries that aren't (or may not be) updatable.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886