MySQL Forums
Forum List  »  Microsoft Access

View doesn't work correct
Posted by: ralph.dollinger
Date: November 08, 2005 07:23AM


i have installed the latest MySQL 5 and the latest ODBC-Driver on my notebook. Everything works fine. But now, there's a problem i can't solve:

First i create a simple view on the MySQL server with one simple "Where"-statement. On the server the view works very well.
Then i make a connection with the ODBC-Driver between MS-Access2000 and the view. After that i open the view in Access, but it doesn't work right. The view ignors the "Where"-statement completely and shows all data records.

Where's the mistake?
Thank you.

Options: ReplyQuote

Written By
View doesn't work correct
November 08, 2005 07:23AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.