none
Compatibility RRS feed

  • Question

  • My access  database created with access 2016 does not wanna work well when I am opening it in access 2010 or 2013. When am using the search box, the moment I start typing, the access launch an error message "Access has topped working". what could be the problem and how can I solve it?

    Please help.

    THANK YOU

    Monday, November 14, 2016 1:37 PM

All replies

  • Welcome to the MSDN forums.

    Like with all programs, Access is Backwards compatible (ie 2016 can run 2010), but if not forward compatible (ie 2007 cannot run 2016). This is understandable as when V2007 was created 2016 did not exist so it can not accommodate for the change made over the years.  This is why, when developing any Access database, you always do your development using the oldest version which will be used to run your database.  So in the above scenario, you need to do all your development using Access 2010.  By doing so, if coded properly, your database will then run properly in Access 2010, 2013 and 2016.


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, November 14, 2016 3:16 PM
  • Hi Tangeni,

    are you trying to access the db and modify using multiple versions?

    or you are just opens the db to view the data.

    did you try to compact and repair the database?

    if not you can try to do that.

    it is possible that when you use the same db with multiple versions of Access and when you save that time something get changed and it does not supported with other version or get something corrupted.

    so please try to compact and repair it and let us know about the result.

    visit the link mentioned below to get more information regarding compact and repair.

    Compact and repair a database

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, November 15, 2016 5:11 AM
    Moderator
  • Yeah I did the compact and repair but it did not help. Basically the DB is opening but there is just one problem of the search box not workin. The moment you start typing in the Name you want to retrieve. The whole database just closes after launching  this: One box Mgs for Microsoft Visual Basic and the another one for Microsoft Access which reads "Microsoft Access has stopped working, A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

    Am unable to attach a picture now. otherwise I could show you what am getting here.

    Tuesday, November 15, 2016 10:45 AM
  • Using 2010, did you try creating a new blank db and importing everything.  Then Compile your VBA project to ensure there are no error.  Then, do all your development using 2010, and only 2010.

    If the error persists, you could also try an Office Repair in case something is wrong with your Office installation (they become corrupted at times).


    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net


    Tuesday, November 15, 2016 2:24 PM
  • Hi Tangeni,

    I agree with the suggestion given by the Daniel  Pineault.

    you can try to create a new db in Access 2010 and check in that newly created db are you able to use the search box.

    maybe problem is in the Access Application itself and not in the db.

    so you can try to implement the suggestion given by the Daniel  Pineault and let us know about the result.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, November 17, 2016 12:30 AM
    Moderator
  • This problem can also occur when a macro or vba code goes into an endless loop or other commands that cannot be interpreted or executed properly by ACCESS. Make sure you check any macro or vba code that is executed when the text box is changed or after text is changed. Look in the text boxes On Change, Before Update and After Update events in particular, but there may be other events firing as well.

    Thursday, November 17, 2016 2:16 AM
  • Even after converting the db the problem persisted. I believe I just have to recreate the database using Access 2010.

    Develop the best app/tool

    Friday, November 18, 2016 10:35 AM
  • Hi Tangeni,

    did you try to create a db in Access 2010 and test the search feature on it?

    did the search feature working correctly with that database?

    if not, then try to repair the MS Office.

    the issue is related with Access Application.

    not related with db.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, November 21, 2016 1:46 AM
    Moderator