If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL Server Backend is Read Only
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. Mike P |
#2
|
|||
|
|||
SQL Server Backend is Read Only
How are you connecting to the backend? With ODBC?
-- Milton Purdy ACCESS State of Arkansas "Mike P" wrote: 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. Mike P |
#3
|
|||
|
|||
SQL Server Backend is Read Only
Does every table have a primary key defined and does Access recognize the PK?
-- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Mike P" wrote: 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. Mike P |
#4
|
|||
|
|||
SQL Server Backend is Read Only
Yes, I Linked to the SQL Server tables by using the ODBC data source.
"golfinray" wrote: How are you connecting to the backend? With ODBC? -- Milton Purdy ACCESS State of Arkansas "Mike P" wrote: 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. Mike P |
#5
|
|||
|
|||
SQL Server Backend is Read Only
No, ever table does not have a Primary Key. Access does recognize the tables
that do have PK's though. "Duane Hookom" wrote: Does every table have a primary key defined and does Access recognize the PK? -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Mike P" wrote: 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. Mike P |
#6
|
|||
|
|||
SQL Server Backend is Read Only
You need to put PKs on every table. You will not be able to delete from any
table that does not have a PK defined. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mike P" wrote in message ... No, ever table does not have a Primary Key. Access does recognize the tables that do have PK's though. "Duane Hookom" wrote: Does every table have a primary key defined and does Access recognize the PK? -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Mike P" wrote: 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. Mike P |
#7
|
|||
|
|||
SQL Server Backend is Read Only
You MAY need to put PKs on every table. You will not be able to
UPDATE OR INSERT from any table that does not have a PK defined. On May 25, 7:50*am, "Douglas J. Steele" wrote: You need to put PKs on every table. *You will not be able to delete from any table that does not have a PK defined. -- Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/DJSteele (no e-mails, please!) "Mike P" wrote in message ... No, ever table does not have a Primary Key. *Access does recognize the tables that do have PK's though. "Duane Hookom" wrote: Does every table have a primary key defined and does Access recognize the PK? -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/...ddbuz/threads? "Mike P" wrote: 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. Mike P |
#8
|
|||
|
|||
SQL Server Backend is Read Only
"a a r o n . k e m p f @ g m a i l . c o m" wrote
You MAY need to put PKs on every table. You will not be able to UPDATE OR INSERT from any table that does not have a PK defined. Who are you and what have you done with Mr. Kempf? I know you're not him because you aren't giving his standard advice! |
Thread Tools | |
Display Modes | |
|
|