Combobox cause a new connection

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Recently, we converted an Access back-end to SQL server and discoverd
hundreds of connectons per hour for about 25 people using it. Finally, we
figured out that very combo box with a table query as rowsource created a
new login every time the form is loaded. We're using windows authentication,
so no user/password is required...fortunately!

Is there any way around this?
 
You could leave the ComboBox RowSource empty and set it in the Enter
or GotFocus event of the ComboBox control.
Click to expand...

Well, it didn't solve the problem. There has to be something at database
level, either front end or back. Anybody know?
 
Are you still convinced it is the ComboBoxes that are causing the
problem?
You could leave the ComboBox RowSource empty and set it in the Enter
or GotFocus event of the ComboBox control.
Click to expand...
[quoted text clipped - 6 lines]
Is there any way around this?
Click to expand...

Well, it didn't solve the problem. There has to be something at
database level, either front end or back. Anybody know?
Click to expand...
Click to expand...

Yes, ween the combo boxes are removed, there's only one login.
 
Have you tried using a persistant connection?
http://www.granite.ab.ca/access/performancefaq.htm
Are you still convinced it is the ComboBoxes that are causing the
problem?
Click to expand...
[quoted text clipped - 7 lines]
Well, it didn't solve the problem. There has to be something at
database level, either front end or back. Anybody know?
Click to expand...

Yes, ween the combo boxes are removed, there's only one login.
Click to expand...
Click to expand...

I suppose it's worth a shot, but the main form of this app is open all the
time. We just hide it when other forms are called. I'm presuming the bound
recordset is open whenever the form is.
 
Rick said:
That's a thought. Thanks!
Click to expand...

What "real" problems are the connections causing? Would you have even known
about them had you not looked for them?

I have the same setup with a few hundred users and it has never been a
problem.
 
Back
Top