We have developed several InfoPath forms with database lookups via rules that are used throughout the country. The forms and (Access) database that stores the queries used to retrieve data (for lookups) are housed on a shared drive. The forms have about 5 data connections. Recently we rolled em out to our London office. The forms load very slow in London. That is because Access is sending the whole mass of data down the wire --
Is there anything I can do to speed this up...I know moving the data to SQL Server should speed it up but it we do that IT takes the project and we lose our flexibility. Would having this under Sharepoint and Access help, or is this simply a shortcoming of the Access JET engine...
Thank you.........