Java + MSAccess + access function

[Belgarath]

Hello,

I need to make queries on Ms Access database (which is on a server)
from a java applet (which is on the same server).

The connection works and i can make some queries without problem

BUT some of these queries are made thanks to Access functions in VBA
and when i execute them an exception is thrown ... :

java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access]
Fonction 'TempsOuvre' non définie dans l'expression.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:
338)
at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:
253)

How can I execute these queries ? Is there any way to load these
functions ?

Thank you all

..

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I need to make queries on Ms Access database (which is on a server)
from a java applet (which is on the same server).

The connection works and i can make some queries without problem

BUT some of these queries are made thanks to Access functions in VBA
and when i execute them an exception is thrown ... :

java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access]
Fonction 'TempsOuvre' non définie dans l'expression.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:
338)
at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:
253)

How can I execute these queries ? Is there any way to load these
functions ?

You can not use VBA functions when accessing a Jet database via
ODBC.

You will need to move functionality from the database to
the application.

Arne

PS: The JDBC-ODBC bridge is not suited for production usage.