Solved

MS Access 2007 / MS SharePoint:  “You can’t assign a value to this object.”

Posted on 2011-03-11
4
353 Views
Last Modified: 2012-08-13
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.

Thank you
0
Comment
Question by:cgraziano
  • 3
4 Comments
 
LVL 84
ID: 35110661
The error means exactly what it says. Can you determine what "object" the error refers to? What exactly is happening when you get the error? By that, I mean is the user clicking a button, entering text, etc etc.

FWIW, SharePoint is not really a great platform for Access (or any relational database for that matter). It's getting much better, and support for SP in Access 2010 is a HUGE improvement over 2007.
0
 

Accepted Solution

by:
cgraziano earned 0 total points
ID: 35110764
Thank.  To answer your question, 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.  The user then pushes a button on the secondary form, which then enters the information into a textbox on the main.  Thats when I get the error.  

I was just recently playing around and form and remembered the Record Locks property.  I changed the field from "Edited Records" to "No Locks".  This seems to have fixed the problem.
0
 

Author Comment

by:cgraziano
ID: 35212125
Thank you
0
 

Author Closing Comment

by:cgraziano
ID: 35239191
Changing the Records Lock property did the trick.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question