November 5, 2007 at 9:28 am
I am using SqL Server 2005 Express to house the data and an Access 2007 adp front end. I end up with read only data. Using an Access 2007 mdb (accdb) I have read and write capabilities. Is there a way to allow read/write from the Access adp file?
November 5, 2007 at 10:59 am
It sounds like your connection account (what you used to set up the connection) doesn't have write permissions on SQLExpress. It may also be that you have no primary key set up on certain tables, which "confuses" ADP's and makes them read-only.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
November 5, 2007 at 1:03 pm
Thank you. The primary key enabled the read/write functionality. Many thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply