?
Solved

Subform won't allow additions on 2010 but works fine on 2007

Posted on 2012-12-31
6
Medium Priority
?
341 Views
Last Modified: 2013-01-25
I developed a database on MS Access 2007 and it's been working fine on many machines for many years. We have now copied the front end file to a new machine that is running MS Access 2010 and I am having a problem on one of the subforms. The subform will not allow new records to be added. The front end was just copied straight accross - no changes - from a 2007 machine to a 2010 machine. All the settings appear normal. Does anyone know what may have changed in 2010 to cause this strange behaviour?
0
Comment
Question by:Rob4077
[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
  • 2
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 1336 total points
ID: 38732239
Can you confirm that other aspects of the app are working normally- you can add/modify/delete records in other forms, for example.

Do you get any errors if you Debug>Compile the app?
0
 

Author Comment

by:Rob4077
ID: 38732270
No errors when I compile and I haven't found any other peculiarities. It appears that this is the only form that is playing up.
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 1336 total points
ID: 38732307
it would be ideal if you could post a file containing the problem form & associated tables/queries.

If you can't do that then at least create for yourself a new database and import just the form and any required tables/queries to see if the problem persists.

If it does then we need to know (at least the following)..
-the sql of the recordsource for the subform
-the link fields between the main form and the subform
-any code in the subform
-the exact nature of the problem- can you move to a new record? do you get any error messages, for example.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 664 total points
ID: 38732551
1. Normally it is recommended that you create a new blank database in the newer version (2010) then import all the objects from the 2007 DB.

2. What happens if you just created a new subform from scratch?
0
 

Author Comment

by:Rob4077
ID: 38745827
Sorry about my delay getting back to this. I have been inundated with work plus had a sick day. I will see if I can do a few tests this weekend and respond.
0
 

Author Comment

by:Rob4077
ID: 38820780
I've had a change of jobs and so finding time to resolve this on a machine that has MS Office 2010 is proving impossible. I will need to close this question and raise it again when I have time to follow it through.

In fairness your answers haveanswered my question - there is nothing known that has changed in 2010 that would be causing this problm.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

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 …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

771 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