Help! Microsoft Access 2003 issue with linked tables.

[Guest]

I have a Microsoft Access database and tables are linked to the SQL Server
2000 database. In other words, I can see my SQL server database tables via my
Access database.
I created a Read Only user in the SQL Server and grant permission only to
view/read the tables. I use that SQL user in my connection string, which link
my Access database and SQL Server database.
Now when I try to delete or insert a record in a linked table in the Access
database I’ m still allowed to do it. Which is so weird.

When I try to delete, insert or update a record in the SQL Server, using the
same username within the SQL Server, I ‘m getting the message saying “You do
not have permission to modify recordsâ€. Which is it suppose to be like that.

My question is why access allow me to delete/update/insert records, when I
use the same user name in the Access connection string. I did re linked my
tables, but still the problem remains.
Please help.

raj

 

[Guest]

I fixed this issue. I had to create a another new ODBC setup, which uses the
new username that I created in the SQL Server database.
Now another issue raised up. When ever I open my access database it prompt
me to log in screen. Once I logged in with the newly created username and the
paswword then I can use all the fucntionalitied in my database. So this login
screen appears only for the first time.
How to stop the login screen appears, when ever I log in to the database.?