Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-11
4
Medium Priority
?
358 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 85
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

730 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