>>I know this is going to sound kind of weird without going into detail...but I have an application running with it's usual database. I then open tables from another database within the application, which in turn opens that database. When I am done with it I need to close the second database. How can I specify that database to close so that the app doesn't close the main database?
>>
>>TIA!
>
>Searching through the help, there seems to be nothing similar to SELECT DATABASE. Perhaps OPEN DATABASE, for an already open database, would select the desired database?


SET DATABASE specifies the name of an open database to be made the current database. I guess I can use that and then use CLOSE DATABASE. Does anyone know whether or not this will work?