MySQL Forums
Forum List  »  Microsoft Access

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

Hello,

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


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


Sorry, you can't reply to this topic. It has been closed.

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.