cannot add new records to 2010 database (used to be 2003)

[KahluaFawn]

I just upgraded from Access 2003 to Access 2010 and can not even add a simple record. Can anyone give me a clue or point me to some literature as to what I need to do?



Is that information out there concerning other 2003 to 2010 conversion problems.

Thanks.

[RuralGuy]

This link should help: http://allenbrowne.com/Access2007.html

[RuralGuy]

Please reply in this public forum so all may benefit.

[RuralGuy]

Is your new db in a "Trusted Location"? http://www.btabdevelopment.com/ts/de...aspx?PageId=13

[KahluaFawn]

I noticed that my table CSM Members would let me add my records at all.

So I went back to look at my form for adding CSM Members. The form is populated via a query which has two combo boxes. The StateID in the CSM Members table is linked to the table State and the CountryID in the CSM Members table is linked to the table Country.

Using the drop down lists displaying the information in the state and country tables allowed easy entry into my major CSM Members table.

When I went back to my query CSM Members, I found I had several other miscellaneous tables linked to the table CSM Members ... but they were to be activated in the DISTANTA future. Evidently, 2010 didn't like my links, so I delete all the relationships but the two actually being used (state and country) and the application now works just fine. YAY!

Thanks for your help. KahluaFawn

[RuralGuy]

Great! So you are ready to use the Thread tools and mark this thread as Solved?