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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
