SQL Server is Read Only

[Mike P]

I have upsized my access program backed to SQL Server Express 2008 using the
SQL Server Migration Assistant. Everything seems to be working fine in query
mode only. That is, my Access program can access the data in the database.
However, if I try to do an Update or Add Record. I get an error message that
the Backend SQL Server Database is Read-Only.

I looked at the Backend database from SQL Server Management Studio and
ReadOnly is set to False.

It looks like the problem may be the way I linked the Backend or the way
Access opens the SQL connect.

Any ideas what I need to do to make Access 2007 access the SQL Server
Express backend database not in a ReadOnly mode?

Thanks in advance for your help. I am totally stuck right now.

[Mary Chipman [MSFT]]

Did you create a primary key on the SQL Server tables? That's usually
the problem in these cases. Access needs a primary key in order to
handle concurrency issues on the back end tables. HTH,

--Mary

On Mon, 24 May 2010 01:41:01 -0700, Mike P

Post by Mike P
I have upsized my access program backed to SQL Server Express 2008 using the
SQL Server Migration Assistant. Everything seems to be working fine in query
mode only. That is, my Access program can access the data in the database.
However, if I try to do an Update or Add Record. I get an error message that
the Backend SQL Server Database is Read-Only.
I looked at the Backend database from SQL Server Management Studio and
ReadOnly is set to False.
It looks like the problem may be the way I linked the Backend or the way
Access opens the SQL connect.
Any ideas what I need to do to make Access 2007 access the SQL Server
Express backend database not in a ReadOnly mode?
Thanks in advance for your help. I am totally stuck right now.

[Jeff Boyce]

You didn't mention permissions ... do you have other than ReadOnly
permissions on the tables?

Regards

Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Post by Mike P
I have upsized my access program backed to SQL Server Express 2008 using the
SQL Server Migration Assistant. Everything seems to be working fine in query
mode only. That is, my Access program can access the data in the database.
However, if I try to do an Update or Add Record. I get an error message that
the Backend SQL Server Database is Read-Only.
I looked at the Backend database from SQL Server Management Studio and
ReadOnly is set to False.
It looks like the problem may be the way I linked the Backend or the way
Access opens the SQL connect.
Any ideas what I need to do to make Access 2007 access the SQL Server
Express backend database not in a ReadOnly mode?
Thanks in advance for your help. I am totally stuck right now.