I have an old Access Database which was imported recently into Access 2007. Ever since this happened it has become more and more prone to good data suddenly becoming corrupt (looks like Chinese characters) and reports just not running. Not to mention searches that work one day then are broken the next (and stay broken).
This being the case, I'd like to see what it takes to move the data to SQL Server permanently, and alter the vba code (if this is necessary) to accommodate it.
I'm looking for general guidelines and advice from individuals who have already done this sort of migration.