My computers were recently upgraded from Windows XP and Office 2007 to Windows 7 and Office 2010. I am responsible for three Access databases that are used by some of our affiliates. I recently made changes to those files in Access 2010, and now our affiliates are receiving error messages when they use the files. The files will not compact - they receive an error message that they do not have the correct version of Access to do that. I had Access 2007 installed on one of my computers and receive the same error when I try to compact the databases. The changes I made included modifying queries, relinking a table from a SQL Server database, and changing a couple of macros.
They also receive a warning that the files are incompatible.
I made new files using Office 2007, imported the objects from the files I'd worked on in 2010, and asked one of our affiliates to test the file. Same issues except he did not receive the compatibility warning.
Have any of you experienced issues with these two versions of the file? One person asked if the problem was the operating system, not Access. Is that a possibility?
Any guidance will be appreciated.