Hi,
My company has a database created on Access 2007 that is linked to our company's Sharepoint. Authorized users can go onto this access file and make edits that are automatically shared to the site. This works fine on Access 2007. However, the company is upgrading to Office 2010, and colleagues are finding out that when editing data on the database within Access 2010, Access hangs and nothing can be done. In the meantime, we have resorted to going back to 2007 until something is figured out. One solution I have come up with is using the Work Offline feature, making the edits, and then going back online and publishing the changes. That seems to work. However, it is not a very good long-term solution. So the question is, does something have to be done with the original file for it to work with Access 2010? I've read online that in terms of backwards compatability, any web connections must be deleted and recreated going from 2010 to 2007. Is that true going from 2007 to 2010? Or is there something else that I'm missing? Thanks for any help.
Nigel
My company has a database created on Access 2007 that is linked to our company's Sharepoint. Authorized users can go onto this access file and make edits that are automatically shared to the site. This works fine on Access 2007. However, the company is upgrading to Office 2010, and colleagues are finding out that when editing data on the database within Access 2010, Access hangs and nothing can be done. In the meantime, we have resorted to going back to 2007 until something is figured out. One solution I have come up with is using the Work Offline feature, making the edits, and then going back online and publishing the changes. That seems to work. However, it is not a very good long-term solution. So the question is, does something have to be done with the original file for it to work with Access 2010? I've read online that in terms of backwards compatability, any web connections must be deleted and recreated going from 2010 to 2007. Is that true going from 2007 to 2010? Or is there something else that I'm missing? Thanks for any help.
Nigel
