Security issue to access database with user logons
Posted on 2004-04-15
I have a very simple vb6 app talking to a access database (97)
i am using a system dsn odbc connection,
i am running on win XP pro.
Now i have to user accounts
1. Admin account
2. Normal User account
my application runs fine under the Admin account
but when i log off and log on as the normal user, i get an odbc
error, this is the error
"-2147467259 - ODBC Microsoft Access Driver - operation must use an updateable query"
bo when i am logged on as user, i checked that the database file is not read only
Now i can read values from the database, but as soon as i try to insert or update a
record in the database, i get this error.