Hey Thanks Dave, That is the command I was looking for. I had remembered seeing something like this before but never had to use it then... THANKS!!! Have a great weekend! -Philip
Dave Crozier wrote: > Philip, > Sorry I hit the send button too soon. > > Also, using only VFP calls, if you use Automation then CreateObject() will > always open a new version of the application whereas GetObject() will open > an existing version and you could then always use automation to see if the > databases is open already. > > If you decide to use Automation extensively then I suggest Tamar's book > Microsoft Office Automation with Visual Foxpro" from Will at Hentzenwerke. > > Although she doesn't cover Access in the book there is extensive coverage of > the models that M$ use for Word, Excel and Powerpoint and the techniques > remain the same for Access. > > Dave C > > -----Original Message----- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Philip Borkholder > Sent: 05 June 2009 00:14 > To: profox@leafe.com > Subject: VFP and MS ACCESS API > > Hi All, > It's been a long time... > Is there a way in VFP code to see if MS Access is already running with a > DB open? > If so, can I capture that instance and assign it to an object variable > so I can control it? > > Thanks, > > Philip B. > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/4a29717e.9090...@netzero.net ** 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.
