DataBase - Access runtime automation

Asked By Loterken

19-Mar-10 04:59 PM

if only access runtime is installed (not office)
can access runtime be used as an automation server ?
if so, with late and early binding
tia

19-Mar-10 05:10 PM

To the best of my knowledge, yes.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

19-Mar-10 06:09 PM

You cannot use CreateObject to create an Access application from the runtime
but you can use a Shell comand to open one and then use the GetObject
function to get a reference to that instance.  See the following article for
more details:

http://support.microsoft.com/kb/145707

For early binding, I do not know but as they are many different versions of
Access, my first reflex would be to use exclusively late binding.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

20-Mar-10 08:36 AM

As Sylvain points out, you sort of can.

The problem is if you create an instance of the access runtime, because you
cannot supply the file name to open when you do this, the runtime actually
shuts down by itself.

However what you can do is shell out and launch a copy of the runtime using
shell. When you do this, then you can provide the access database files open
as a parameter in that shell command.

Once the addition of Access is launched and running, then you can use get
object in your code.

So you are free to use late binding, and in fact I think even early might
work, but you cannot use create object, you have to use get object to get a
running instance of access.

So the only change or limitation is that you have to have Access running and
launched before you attempt automate access runtime.

The above limitation does not exist for the full Eddition of Access, but as
the KB article linked to shows you can well work around this limitation.


--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com