link table? -- sql server programming

ll
2/5/2004 11:43:53 PM

Hi, I create a user(user1) only have "read" permission in SQL server. and
through ODBC(use user1) and Access to create a link table to access the sql
server database.
At my clinet's computer, I at least saw two situations:
1. one of the computer, Access still can modify the link table but won't
save to sql
2. can modify the link table and the changes saved to sql.

I think the normal way shouldn't have permission to WRITE(UPDATE) table.
what's happening? how to track it down? thanks...

LL
2/6/2004 12:09:01 PM

Actually I found when I create the new DB, and build the link talbe, it's
ready only.
Only after I copy it to another user's profile folder(c:\C:\Documents and
Settings\if.CDE\desktop)
then the the link table change to can writable?

and in the sql trace tool, it shows "cde\if" as the NTUserName to execute
the query not the connected user(readonly)?

Any ideas? thanks.

[quoted text, click to view]

sql server programming : link table?