Access 2007, Runtime and DAO

[Woody]

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?

 

[Albert D. Kallal]

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.

 

[Tom Wickerath]

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/
__________________________________________

 

[David W. Fenton]

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.