By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Deploy Access

P: n/a
I am trying to deploy an Access Database to unknown end users.
Currently I have a VB program that asks if they have Access 2002 or
later installed and then will load with or without run time depending on
their answer. I have found this simple question quite complex for some
of my users and am wonder if anyone knows of code that can do this
search automatically. Any help would be greatly appreciated.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 02 May 2005 20:37:16 GMT, Coy Howe <cf*@olypen.com> wrote:

You could write code like this (off the top of my head). Note: this
code says NOTHING about other versions of Access such as 2003, which
may very well be able to run your app as well.

Function IsAccessXPInstalled() as Boolean
dim obj as Object
dim blnReturn as Boolean
set obj = CreateObject("Access.Application.10)

' As you imagined, this is the code for Access 2003:
'set obj = CreateObject("Access.Application.11)

if obj is nothing then
blnReturn = False
else
set obj=nothing
blnReturn=True
end if
IsAccessXPInstalled = blnReturn
end function

I am trying to deploy an Access Database to unknown end users.
Currently I have a VB program that asks if they have Access 2002 or
later installed and then will load with or without run time depending on
their answer. I have found this simple question quite complex for some
of my users and am wonder if anyone knows of code that can do this
search automatically. Any help would be greatly appreciated.

Thanks

*** Sent via Developersdex http://www.developersdex.com ***


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.