Menu
A database created with one of the new sort orders will not open in Access 2007 even with Service Pack 2 (SP2) installed.
893
In Access 2010, from the File menu, select Open. In Access 2007, click the Office Button, and then click Open.
You may be 'unable to open Access database over network' when you don't have sufficient privileges to the folder where the database for shared use is stored. Or, such an issue may occur due to corruption in the database files (. accdb or . mdb).
On the Tools menu, click Database Utilities, click Convert Database, and then click to Access 2002-2003 file format. Enter a name for the database, and then click Save. Exit Access 2003. Open the database in Access 2013 or later version of Access.
There is a list of compatibility issues : http://msdn.microsoft.com/en-us/office/cc907897, which includes sort order, however the big gottcha is not stressed, and that is General sort order. This is not the same as General sort order in previous versions of Access, it is new. For compatibility, you must choose General Legacy sort order.
200
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
