Re: Views accessed as table in MS Access
Daniel Kasak <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc,gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
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]