J
JoBless
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 'å'
(a-å is the entire alphabet in danish)
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 wrong result again.
This error is only present when I use a database which is secured with the
userlevel security wizzard.
OS: windows2000 DK / WinXP Pro DK
Can this de fixed, or is it a Microsoft Bug?
Regards
JoBless
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 'å'
(a-å is the entire alphabet in danish)
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 wrong result again.
This error is only present when I use a database which is secured with the
userlevel security wizzard.
OS: windows2000 DK / WinXP Pro DK
Can this de fixed, or is it a Microsoft Bug?
Regards
JoBless