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:[EMAIL PROTECTED] Sent: Sunday, November 12, 2006 2:06 PM To: C K; [email protected]; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
