I have written a query to allow record-level access
depending on the user. This makes use of the CurrentUser
function. I am then using a data access page to connect to
the database via the query. When run from within the
database both the query and the DAP work fine, but when I
try and run the page from outside the database (using IE6)
I get an error message "Undefined function 'CurrentUser'
in expression".

Anyone got any suggestions?

Many thanks,

Nick.

When you run queries against Access from outside of Access, your only
connection to the database is through the Jet engine, which doesn't know
about many of the Access functions (and definitely none of the user-defined
functions). Afraid there's no work-around that I'm aware of either.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Nick" <(E-Mail Removed)> wrote in message
news:018301c34c7c$132392e0$(E-Mail Removed)...
> I have written a query to allow record-level access
> depending on the user. This makes use of the CurrentUser
> function. I am then using a data access page to connect to
> the database via the query. When run from within the
> database both the query and the DAP work fine, but when I
> try and run the page from outside the database (using IE6)
> I get an error message "Undefined function 'CurrentUser'
> in expression".
>
> Anyone got any suggestions?
>
> Many thanks,
>
> Nick.