new project, existing data, opens read only

From: Dan H (anonymous_at_discussions.microsoft.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 08:28:10 -0700

I have converted an Access DB to run on SQL7. I am
attempting to create an Access (2002 and 2003) Project to
manage this DB. No matter what login I put in the
connection properties, I can't Insert or Update records.
All options relating to those things are greyed out.

I have connected using:
NT login, default settings
NT login, specific permissions to tables (insert, update,
etc)
new SQL login, default settings
new SQL login, specific permissions to tables
new SQL login, DataWriter role (also DataReader, Public,
and DBOwner)
I have even tried with the sa account with the same
results.

Relevant Pages

  • Re: new project, existing data, opens read only
    ... I can't Insert or Update records. ... > NT login, specific permissions to tables (insert, update, ... > new SQL login, default settings ... > new SQL login, specific permissions to tables ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Riddle me this error ADODB.Recordset (0x800A0E7A)
    ... Authenticating your users is fine, but when you're doing that, yes, it will ... not let anyone in who doesn't have permissions, well, since, that's what ... Does SQL Server need to know who is accessing your intranet? ... need to pass that person's credentials for SQL login purposes. ...
    (microsoft.public.inetserver.asp.general)
  • Security: Allowing users to see results of view, but not design view of view
    ... I'm setting up a view so someone using a specific SQL login and ... password can view the returned recordset, but cannot see how the view ... was developed in design view, or add additional fields that were not in ... What permissions do I give them? ...
    (microsoft.public.sqlserver.security)