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: [email protected] [mailto:[email protected]] On Behalf Of Philip Borkholder Sent: 05 June 2009 00:14 To: [email protected] 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: [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/572661af476c4e26b4bf4f376951f...@develop ** 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.
