Database Connected to SQL Server is Read Only

  • Thread starter Thread starter mj
  • Start date Start date
M

mj

Hi. I have a SQL Server database that I'm trying to link
to using an Access MDB file, but all the data is read only
when I try to edit or add anything using Access forms. Any
thoughts? Thanks!
 
I put in primary keys but still no luck. Does it matter
that I'm using a file DNS? Should I switch to a system
DNS? I have about five people using different machines. Do
I need to create a system DNS on each machine?
 
You need a unique key to be able to change data, also you
need update ,insert access to the database/tables.
It is also a good idea to have an identity column, this
allows Access to see if data has changed since you read
it.

As a test you could try the dbowner login for the database
and see what happens.
 
Back
Top