Solved

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

Posted on 2011-03-11
4
354 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

732 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