Dave Sorry I have not worked with datasessions before (excuse for ignorance) so:
The code I am modifying is a method of an existing form which has a DataSession property of 2 (Private). How would I open a new datasession in the middle of the existing method code ? How would I close the new satasession when I am through AND How would I restore the original datasession Paul Dave Crozier wrote: > Paul > The "close database all" operates on the current datasession, so can't you > simply open a new datasession to open the database in, do your bits and > pieces, then close databases all and return back to the original session. > > Obviously if you need data from tables in the first session this will close > problems, but you can always open the original database again in the new > session as well. > > Dave Crozier > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Newton > Sent: 03 October 2007 12:47 > To: [email protected] > Subject: Erasing a temporary DBC > > Hi > > I am working on modifying an existing piece of code. When this code > runs there are several databases (DBCs) already open and I need to leave > these open after my mods have been run: > > Beginning part of original code > My Code > Last part of original code > > In my code I am creating a temporary DBC, and subsequently adding and > dropping tables. I am ensuring that none of the tables belonging to > Temp.DBC are open when I am through. Now I want to ERASE the Temp.DBC > (etc) files from disk and cannot do so because I cannot find a way to > close Temp.DBC > > Any suggestions ? > > Also how can I save (and restore) the current database setting (before > and after my code) > > Thanks > > Paul Newton > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
