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

[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.

 

[Maurice]

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