I am using MS Access connecting to SQL Server using the standard MS Access form recordsets. I have a client form that has multiple subforms. Often MS Access will generate a new connection for a subform rather than using the existing connection. The client form above will generate up to 7 connections instead of making a new recordset on the existing connection.

Anyone solved this riddle yet?

Ben Taylor - MCSD
btaylor@premiersi.com