I am creating an application that I would like the client to be able to use
via Access 2007 runtime. I have code like the following:

Dim dbCurr As DAO.Database
Set dbCurr as CurrentDB()

The above code works when I have the following reference checked in my VBA
tools References section: Microsoft Office 12.0 Access datagase engine Object.

My question is this: Do I have to do anything special with regard to the
runtime in order for the runtime to make use of the above code? Do I have to
do anything special or can I simply install runtime on a client machine and
copy my application over? I know I have issues to solve with regard to
trusted locations on the client machine, but other than that if I do the
above will things work?

"Woody" <(E-Mail Removed)> wrote in message
news:B01F8EB1-89D8-4F03-BEF2-(E-Mail Removed)...
>I am creating an application that I would like the client to be able to use
> via Access 2007 runtime. I have code like the following:
>
> Dim dbCurr As DAO.Database
> Set dbCurr as CurrentDB()
>
> The above code works when I have the following reference checked in my VBA
> tools References section: Microsoft Office 12.0 Access datagase engine
> Object.
>

the above looks good...


> My question is this: Do I have to do anything special with regard to the
> runtime in order for the runtime to make use of the above code?

You should be just fine with the above, you don't have to do anything..

> Do I have to
> do anything special or can I simply install runtime on a client machine
> and
> copy my application over? I know I have issues to solve with regard to
> trusted locations on the client machine, but other than that if I do the
> above will things work?

Nothing else need be done. The problem area is often if they have an
different version of access and they use some other access application
based on that different version.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)



>
>
>
>

Woody,

To add a little to Albert's reply, you can click on Start | Run and enter
the following command on your development PC that includes a full version of
Access to simulate the run-time environment:

msaccess /runtime "CompletePathToYourDatabaseWithFileExtension"


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"Albert D. Kallal" wrote:

> "Woody" <(E-Mail Removed)> wrote in message
> news:B01F8EB1-89D8-4F03-BEF2-(E-Mail Removed)...
> >I am creating an application that I would like the client to be able to use
> > via Access 2007 runtime. I have code like the following:
> >
> > Dim dbCurr As DAO.Database
> > Set dbCurr as CurrentDB()
> >
> > The above code works when I have the following reference checked in my VBA
> > tools References section: Microsoft Office 12.0 Access datagase engine
> > Object.
> >
>
> the above looks good...
>
>
> > My question is this: Do I have to do anything special with regard to the
> > runtime in order for the runtime to make use of the above code?
>
> You should be just fine with the above, you don't have to do anything..
>
> > Do I have to
> > do anything special or can I simply install runtime on a client machine
> > and
> > copy my application over? I know I have issues to solve with regard to
> > trusted locations on the client machine, but other than that if I do the
> > above will things work?
>
> Nothing else need be done. The problem area is often if they have an
> different version of access and they use some other access application
> based on that different version.
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)

=?Utf-8?B?V29vZHk=?= <(E-Mail Removed)> wrote in
news:B01F8EB1-89D8-4F03-BEF2-(E-Mail Removed):

> Dim dbCurr As DAO.Database
> Set dbCurr as CurrentDB()

You probably meant:

Dim dbCurr As DAO.Database
Set dbCurr = CurrentDB()

Otherwise, you'd have gotten a compile error.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/