Bug #12578 | linked 5.0.11-views fail with Access 97 SR2 | ||
---|---|---|---|
Submitted: | 15 Aug 2005 8:50 | Modified: | 31 Aug 2005 16:45 |
Reporter: | gernot adams | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / ODBC | Severity: | S1 (Critical) |
Version: | 3.51.11-2 | OS: | Windows (Windows) |
Assigned to: | CPU Architecture: | Any |
[15 Aug 2005 8:50]
gernot adams
[15 Aug 2005 13:34]
MySQL Verification Team
I tested with Access 2003 without to repeat the behavior reported (like you have mentioned). Then I just to recommend you for to apply the latest service packages for Access 97 and upgrade your MDAC for the last one.
[15 Aug 2005 14:20]
gernot adams
hi, i have already had installed the latest Access 97-SR (which is SR2b). Now i have installed MDAC 2.8 SP1 too but the problem still remains. To me the problem is that MS Access 97 don't get the right information about the view's name. When Access links tables or views, it stores a local name and a foreign name for the object in the Access system table "MSysObjects" (this table is hidden so go to tools -> options -> view, and select "hidden objects" and "system objects"). For example in the table-window in MS Access you can rename a linked ODBC-table or view to whatever name you wish. This name will be stored in the "Name" column. And the "real" name which is the name of the view or table in MySQL is stored in the "ForeignName"-column. And under Access 97 a "wrong" name will be stored for views and then Access can not find the view. cheers gernot
[15 Aug 2005 22:14]
MySQL Verification Team
Did you deleted the linked view and relinked after the update ? Notice that Access saves the string connection so to delete and relink solves the problem. Also are you using the latest MyODBC ?
[16 Aug 2005 6:14]
gernot adams
hi, i use the latest MyODBC driver (MyODBC-3.51.11-2). After i had installed the latest MDAC (2.8 SP1) i relinked the view. And i also created a new view (one like SELECT * FROM tblBla) but the problem still remains. And i tested it with several Access 97-clients. All clients have Windows 2000 SP4 with the latest MS Updates. The Server is Windows 2003 SP1 with the latest MS Updates. cheers gernot
[26 Aug 2005 9:58]
Vasily Kishkin
Sorry..I tryed to reproduce the bug from MS Access 2003. I have installed MDAC 2.80 on Windows 2003. Could you please test it on MS Access 2003 ?
[26 Aug 2005 10:48]
gernot adams
hi, as i stated in my first posting: this problem doesn't occur under MS Access 2003 but only under MS Access 97. cheers Gernot
[31 Aug 2005 16:45]
Jorge del Conde
I was unable to reporduce this behaviour.
[1 Sep 2005 14:03]
gernot adams
hi Jorge, under what kind of configuration do you tested it? cheers gernot
[5 Sep 2005 6:48]
gernot adams
hi, the problem still remains under MySQL 5.0.12 cheers gernot