I have a VBA application running under MSWord 2007... reads and writes strings, integers and dates to Access 2007 accdb saved on a Sharepoint network location. Performance is great.
Exactly the same code under MSOffice Word 2010 runs at a snails pace (very slowly indeed). The data is accurately and completely retrieved, but the wait is unusable. Each control in the form seems to require approximately the same 45-60 seconds as a new SQL string is sent.
The OS is Win7 64 bit. The Office apps are all 32 bit. The provider string is:
data source=\\server\site\list\; Provider=Microsoft.ACE.OLEDB.12.0;" & "Persist Security Info=False;"
The Microsoft ADO library referenced in the application is 2.5
Any ideas on what to do would be greatly appreciated!