Eliminating SQL Server Connections

[Michael Beck]

I am using Access 2002 as the front end and SQL Server 2000 as the back end.
It is a large app with 75 to 100 user at a time.

I am trying to cut down on the number of connections I have in Access. Like
combo boxes that are populated using addNew instead of a query. However,
the rowsource for some combo boxes is too large for the value list.

I tried using a pass thru query as the rowsource. That works, but the front
end does not seem to release the connection when I am finished with the
form.

Is there some way to force the connection to be released? Something like
qry_pt_dodah.close in the form unload?

Thanks for any help.

Michael

 

[Pieter Wijnen]

you could always use a function to populate instead..

Pieter

 

[Michael Beck]

Thank you for the information, but you did not answer my question.