-
MS Access Has Multiple Connections
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|