Views accessed as table in MS Access

------=_Part_47640_6897023.1163178454957
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,
I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet
4.0. Currently it is not giving the normal problem of Access while inserting
new records (#deleted), but when a View created in database is linked with
MS Access it is not giviing correct results.
e.g. There are two tables 'Accdocs' ad 'Accdoctransactions'. Each
Accdoctransactions has a reerence in Accdocs (MasterDocId-->AccdocId). I
have to access all records from Accdocs and Accdoctransactions. When I
create a view for the same, it is giving correct results when the view is
opened using MySQL Query Browser. Then if I link that table in any MS Access
file, as a linkedtable, it is not gving me correct results. Even I create
the same view as a query it gives same results as Query browser. What is
going wrong? If I use MS SQL Server 2000 then it gives correct results for
above situation.
Is it MySQL ODBC driver probelm? and if yes it is solved in latest ODBC 5
version? or is it Access error? Please help. It's urgent.
Thanks,
CPK

------=_Part_47640_6897023.1163178454957--