I can't call currval() with the odbc driver.

I'm using odbc driver version 8.0.0.2 with MS ACcess 2003.

I get the following error in access

run-time error 3085:

undefined function 'currval' in expression.

How can i make this work?

Thanks







--
With best regards,

Mike Fahey - Systems Administration
************************************************** ******************
ENTER.NET - "The Road to the Internet Starts Here!" (tm)
(610) 437-2221 * http://www.enter.net/ * email:support (AT) enter (DOT) net
************************************************** ******************


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

--- Mike Fahey <mfahey (AT) enter (DOT) net> wrote:

You will need to use a pass-through query, if you want
to use Postgresql syntax, functions, operators etc.
Otherwise, Access assumes that you are attempting to
use an Access function etc.




__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)