Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

927 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