link table?

[ll]

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]

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?

Any ideas? thanks.