Automate MSAccess from Windows .Net app

>From a windows .Net app, I need to 1) check if MSAccess is already open to a
certain Access application. If so, then open a form and find a certain
record. 2) If not open, then open MSAccess and open a secured Access
application and then open a form and find a record. (The Access App is
secured not with a database password but with full user name and password
security.)

I can open the form and find the record OK. I am having problems checking if
the app is already open and opening the secured app.

Using "GetObject" has the problem of finding other instances of MSAccess but
not the database application I am interested in.

I used to use API calls to see if a window was already open with the name of
the MSAccess app but I can't get the API calls to work in .Net

I really would rather not use the shell() function since it has some
problems but I can't see any other way to automate a secured Access
Application.

Any ideas?
--
Brad Burke
FusionData, LLC
970 222-1501
.

Relevant Pages

  • Re: Automate MSAccess from Windows .Net app
    ... First of all, if possible, I'd avoid automate Access app: ... then open MSAccess and open a secured Access ...
    (microsoft.public.dotnet.general)
  • Re: Linked .csv File Locking
    ... I don't know if you are offering this MsAccess app that links to the ... or if your user community has written their own apps ... MsAccess db in the ftp download. ... using and keeping it read-only without locking it up. ...
    (microsoft.public.access.security)
  • Re: Automate MSAccess from Windows .Net app
    ... ' Open a database in exclusive mode: ... "Norman Yuan" wrote: ... > First of all, if possible, I'd avoid automate Access app: ... then open MSAccess and open a secured Access ...
    (microsoft.public.dotnet.general)
  • Re: ADO query to Access not working, no errors
    ... I have an MSAccess query object already in an MSAccess database. ... I can run the query from the VB app, ... You want to run that Query object from a VB app using ADO? ...
    (microsoft.public.vb.database.ado)