Interesting. I also tried using views in Access, and found that it only
gives data from the first table specified. However, when I tried accessing
the same view from OpenOffice using ODBC, it worked fine. Are there any
other ways we can find out if this is a MyODBC error or Access/MSJET?

-----Original Message-----
From: Daniel Kasak [mailto:dkasak@nusconsulting.com.au]
Sent: Sunday, November 12, 2006 2:06 PM
To: C K; mysql@lists.mysql.com; myodbc@lists.mysql.com
Subject: Re: Views accessed as table in MS Access

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

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=clewis.it@gmail.com