C K wrote:

> 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?

Yes. The use of views and stored procedures is not yet stable and is
unsupported.

> and if yes it is solved in latest ODBC 5
> version?

No. I still can't get any action from the latest MyODBC ( v5 ) release.

> or is it Access error? Please help. It's urgent.

Well good luck then, but if you're in a hurry, I'd do something dodgy
like create a temporary table, insert stuff from your view to the
temporary table, link MS Access to that temporary table ( there are some
code snippets in the MyODBC list that should you how to do this in VB ),
and then delete the MS Access link when you're done ( and delete the
temporary table ). You can write a function that does this, and call it
view_my_view() or something


--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au