Cannot edit Access 2007 DB via Form- get "DB opened in Read Only M

  • Thread starter Thread starter Jeff L
  • Start date Start date
J

Jeff L

I created a custom Sharepoint List view using MS Access 2007 (from Sharepoint
list, I clicked "Settings", "List Settings", "Create View", "Access View",
then, once Access launched, I selected the form option "Create a form that
lets you enter information for one record at a time".). All columns that I
created in that list were dumped into the form automatically. I rearranged
them as desired, saved and published the form/DB back up to Sharepoint.
But... no matter where I open the DB (either from Sharepoint, or locally),
the DB comes up in "Read Only" mode. Therefore, I cannot enter new records
in it, in order to update my list. I can, however, update the list from
within Sharepoint, without using my Access Form.

I stepped through the process again to make sure there were no options that
I could've missed, but do not see anything that seems relevant to this issue.
I cannot tell if this problem is related to:
- MS Access security (I have the DB locations added as "Trusted Locations")
- a flag or parameter that I need to change in the code that launches the
form (doesn't seem that way since it happens even when I launch the form
locally)
- a DB setting that was set when I first created the form (I cannot find
anything that seems related to that, either)
- or an Access or Sharepoint bug

Any suggestions on this would be very much appreciated.
 
Jeff,

Shouldn't you check out the database and check in to get what you want? This
has to be done via SharePoint. Give it a try and see if that helps.

hth
 
Back
Top