>I have two forms, frmMain.scx and frmReport.scx. On both of these I have cmbAssyDesc combo box that opens the same database and open the same table for the cmbAssyDesc items. I always get File in use program error. However, if I close one and open the other, I don't get this problem. Please help. Thanks, Sam
Are you adding tables to the Data Environment (dragging them from your database lists into the DE window?) or opening and closing all tables via code? If the latter then you're missing out on much of the beauty of using "visual".
In the DE, you set a property of Private Data Session, equiv. to Open ... AGAIN (which you learned earlier).
Also you can set the DE's AutoOpenTables and AutoCloseTables properties.
So set these, drag your required tables into the DE (in the earlier example you could have dragged several copies of the table into the DE, one for each combo), then forget about them.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.