Bug #12675 Error when linking ODBC tables and then relinking then from Jet Via Code
Submitted: 19 Aug 2005 13:16 Modified: 30 May 2013 7:36
Reporter: Carlos Ochoa R. Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51.12 OS:Microsoft Windows (XP Pro)
Assigned to: CPU Architecture:Any

[19 Aug 2005 13:16] Carlos Ochoa R.
Tengo una base de datos en Access con sus tablas vinculadas al programa. Tengo la misma BD en MySQL usando los mismos nombres para las tablas y campos; las vinculo al programa y todo funciona bien, pero si revinculo nuevamente las tablas de Jet deja de hacer refresco al formulario donde tengo los datos y sale el mensaje "undefined function "NZ" (o cualquier función definida)" cuando llamo consultas que contienen funciones NZ o definidas  desde código VB. si las dejo vinculadas de MySQL todo funciona bien, pero ya no puedo volver a usar las tablas de Access.

Tengo Office 97, DAO 3.51, ODBC 3.51.12 y MySQL Sever 5.0.10a

First, excuse my poor english.
I Have a DB in Access 97 with its tables linked to my front-end. I also have the BD in MySQL with the same tablenames and fieldnames, when I link these tables to the program and then relink them to Jet I get the message "undefined function "nz" (or any user defined function)" when i call any query that includes any function from VBA code. Everything is OK if I only use ODBC but nothing is the same than before when I relink the tables from Jet.

Where may I send a sample of the problem to let you see it?


Carlos Ochoa

How to repeat:
1. Vincule las tablas de Jet, ejecute desde el código alguna consulta que contenga nz()
2. Vincule las tablas de ODBC (todo vía código) y ejecute el código
3. Revincule las tablas de Jet y Ejecute ...

Suggested fix:
[21 Aug 2005 11:27] Vasily Kishkin
Could you please say me what Jet is and where I can download it ? Also I need sample table and view definitions.
[21 Sep 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[30 May 2013 7:36] Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.