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

Need advice on how to confirm Access 2K Library References on atartup

P: n/a
Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Lauren Wilson wrote:
Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW


Here's some links to info on References in Access:

Doug Steele:
http://members.rogers.com/douglas.j....nceErrors.html

MichKa:
http://www.trigeminal.com/usenet/usenet026.asp?1033

This is from the July 1999 issue of SmartAccess.
http://www.smartaccessnewsletter.com...2568AF00149FA4

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q248/9/41.ASP

ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/support.../Q209/8/49.ASP

ACC97: How Access 97 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q280/4/65.ASP

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/support.../Q175/4/84.ASP

ACC: References Not Imported with Objects from Another Database
http://support.microsoft.com/support.../Q181/6/75.ASP

Not sure if all of these links are still valid but the top 2 are
definitely what you are looking for.
--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #2

P: n/a
On Thu, 21 Apr 2005 22:27:07 -0500, John Mishefske
<mi************@JUNKtds.net> wrote:

The Doug Steele link should be:
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

-Tom.

Lauren Wilson wrote:
Hello good folks!

It is WAY past time for me to figure out how to check for the
existence of all referenced libraries on application startup and
provide feedback to the user if they are not.

Do any of fine folks have a link to some sample VBA code that will do
this? The big issue, I believe, is how to make such a procedure
sensitive the various storage locations for the referenced DLLs on
various versions of Access -- 2000, 2002 and 2003

All responses appreciated.

Cheers,

-- LW


Here's some links to info on References in Access:

Doug Steele:
http://members.rogers.com/douglas.j....nceErrors.html

MichKa:
http://www.trigeminal.com/usenet/usenet026.asp?1033

This is from the July 1999 issue of SmartAccess.
http://www.smartaccessnewsletter.com...2568AF00149FA4

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q248/9/41.ASP

ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/support.../Q209/8/49.ASP

ACC97: How Access 97 Resolves Visual Basic for Applications References
http://support.microsoft.com/support.../Q280/4/65.ASP

ACC97: References That You Must Set When You Work with Microsoft Access
http://support.microsoft.com/support.../Q175/4/84.ASP

ACC: References Not Imported with Objects from Another Database
http://support.microsoft.com/support.../Q181/6/75.ASP

Not sure if all of these links are still valid but the top 2 are
definitely what you are looking for.


Nov 13 '05 #3

P: n/a
Tom van Stiphout wrote:
On Thu, 21 Apr 2005 22:27:07 -0500, John Mishefske
<mi************@JUNKtds.net> wrote:

The Doug Steele link should be:
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

-Tom.


Thanks Tom - I'll update my list.

--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.