MSWord 2010 VBA Provider=Microsoft.ACE.OLEDB.12.0; SLOW on Access 2007 accdb

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!

0 answers