Help! Microsoft Access 2003 issue with linked tables.

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

.

Relevant Pages

  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie question on SQL connection
    ... database on my developer machine. ... > to develop databases away from the live SQL server - that way in the ... > domain SQL Server. ... Does your connection string contain a typo? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.sqlserver.connect)
  • Re: .NET and SQL Server on Separate Machines
    ... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Failure of Linked table in Access...
    ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
    (microsoft.public.access.modulesdaovba)