Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 16th, 2003, 01:06 AM
Authorized User
Points: 306, Level: 6
Points: 306, Level: 6 Points: 306, Level: 6 Points: 306, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , .
Posts: 54
Thanks: 2
Thanked 0 Times in 0 Posts
Default Broken References

Without the benefit of having the Office Developer's Edition available, I distribute an MS-Access application to users in a non-executable format (i.e. they must have MS-Access on their PC in order to run the app ...I don't have an installer).

     Normally, in our small group (less than 50 users all running MS-Office 2000), it is not a problem. However, we have a LAN Administrator who is still cutting his teeth. My app refers to an number of .dll's and other libraries that are part of Access but are not normally installed. When the LAN Adminstrator reloads his baseline, sometimes he "loses" the pointers that Access has to my dll's so they are reported as MISSING (broken refs). While the refs are somewhere on the user's PC, Access can't find them and dumps the user out into the VBA Editor.

To overcome this problem, I have compiled a list of all the refs I use, their attributes such as filepaths GUIDs, major, minor, etc and have put them into a table (for purposes of illustration, call it "tblMyRefs").

What I would like to do on Startup, is have my code, enumerate the refs, determine the broken ones, look up the applicable info it needs from my table, and re-establish the links. If it cannot resolve the problem, have it display a message "Problems with dynamic link libraries ... contact the LAN Administrator!" ... just joking about the message, but I would rather have it display a graceful error recovery than leave the user stranded in code.

Can anyone suggest a procedure to do this?

Thank you ahead of time for your help! :)





--- Tom
__________________
--- Tom
 
Old December 16th, 2003, 02:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A possible solution, rather than do all that, is to store the dlls somewhere on your LAN where everyone can get to them (possibly a sub dir of where you keep your db), and change your references to point to those files, rather than the ones stored in "C:\Windows\System32" or wherever.

This would avoid having to even think about creating a startup procedure

Steven

I am a loud man with a very large hat. This means I am in charge
 
Old December 17th, 2003, 10:13 PM
Authorized User
Points: 306, Level: 6
Points: 306, Level: 6 Points: 306, Level: 6 Points: 306, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , .
Posts: 54
Thanks: 2
Thanked 0 Times in 0 Posts
Default

That would work in ordinary circumstances, but there is a lot of security on this LAN and and all workstations. Users (and developers) are locked out of lots of things (registry, certain folders, no installations, etc). One can never count on anything being standard.


--- Tom
 
Old December 17th, 2003, 11:27 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You must work under ordinary circumstances where the so-called network administrators work against any developer with a legitimate need. You could also create a folder on the C: directory of each workstation and move your dlls to that directory. Just send an e-mail to the boneheads who will not allow you to do this and cc someone hier up your chain.
Make sure that first you ckeck with your power users (also known as network admnins) to see if that is acceptable.

There is only one thing that I have found to be standard, This issue.




Sal
 
Old December 19th, 2003, 12:10 AM
Authorized User
Points: 306, Level: 6
Points: 306, Level: 6 Points: 306, Level: 6 Points: 306, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , .
Posts: 54
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Amen!


--- Tom




Similar Threads
Thread Thread Starter Forum Replies Last Post
Broken CD ajb963 BOOK: Beginning Access VBA 19 October 28th, 2006 07:07 PM
SignOut is broken? cohansh1 BOOK: ASP.NET Website Programming Problem-Design-Solution 1 June 21st, 2005 01:09 AM
broken cd waz84792 Flash (all versions) 5 October 22nd, 2004 08:42 AM
Finding "Broken Queries" , etc. tcarnahan Access VBA 0 December 29th, 2003 10:01 PM
Broken Links kilika Forum and Wrox.com Feedback 1 September 15th, 2003 10:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.