Hi.

I have a simple webpage, on which I make a query to my access2000 db.

When I try the following sql:

Select name from table where name between 'a' and 'å'

I get the expected recordset. But when i run the user-level security wizzard
on the db, and connects using my login and password, I get the expected
recordset at the first query, but when refreshing the page, I get a strange
recordset. My sql gives the expected result inside access (which is set up
to norwegian/danish sortorder).
Then I restart the IIS, and again I get the correct result at the first
query, but then I get the wring result again.

This error is only present when I use a database which is secured with the
userlevel security wizzard.

OS: windows2000 DK

Can this de fixed, or is it a Microsoft Bug?

Regards

Kim