Converting from Access 2010 to Access 2013

[howlettb]

Does anything need to be done to change from Access 2010 to Access 2013? I have put a sample copy of our database on a computer using Access 2013 and it seems to work fine, but I keep thinking it can't be that easy. Am I missing anything? If I continue to use this database in Access 2013, will there be any problems when support for Access 2010 ends? Thank you in advance to anyone who can answer that question.

[isladogs]

This link tells you the differences between A2010 and A2013
https://support.office.com/en-us/art...D-9A2DFEF68E2F

Very little was added but several features were removed e.g. pivot tables.
If your database doesn't include any discontinued features you should be ok

One thing worth checking is the vba references.
These should update correctly but if any are marked MISSING you will need to update them yourself.
Then compile the database. Fix any errors if it doesn't compile

[howlettb]

Thank you ... this was really helpful but I don't know what you mean by "check the vba reference" ... and if they are missing ... how do I update them myself?? Thnks

[davegri]

It really depends on how complex the db is. If it runs the first time on the new version, it will continue to do so, no problem.
If it contains code that refers to other Office programs like Excel, Outlook, Word, then it might show syntax errors, because the references need to be updated to the new version (Google Access References). Much of this can be avoided with late binding, but if no problems, don't worry about that.
Another area, fairly rare, is databases that use ActiveX controls. They are very version specific and need to synchronize with the current version. Again if no problems, don't worry about that either.
Most of my databases continue to run OK when I update to new Access versions. The most common problem is with references, but can be fixed in very short order with a bit of knowledge (again Google Access References).

[isladogs]

To check the references, go to Database Tools ... Visual Basic. This will open the Visual Basic Editor (VBE)
in the VBE, go to Tools ...References.
This will show a long list of VBA libraries.
At the top there will be a few libraries ticked which are the ones in use.
If none are marked MISSING, all are OK.
If not, report back for further advice.

Another issues could have occurred if you had used 32-bit Access in 2810 & 64-bit Access 2013 or vice versa.
However you would have got a warning message if there were any 'bitness' issues.