I recently split my MS Access 2007 database using SharePoint as my back end and MS Access as my front end. Initially, everything seemed to work perfectly; however, I have noticed that for some reason I am having problems with the records/forms locking. For instance, I have a main form I use for entering information. From that form I have a button that will open a secondary form which the user selects options, which are then entered into a textbox on the main. I have done this a million times on MS Access, but since splitting the db for some reason I keep getting an error stating that “you can’t assign a value to this object.”
This is driving me insane. Please help.