Access 2003 crash with custom libraries

  • Thread starter Thread starter Jeffrey Ah-Chong
  • Start date Start date
J

Jeffrey Ah-Chong

Hi

I have an application developed in access 2003, which loads custom
libraries(also in access 2k3). The problem is that everytime a library is
modified (a property/function/ whatever) then the development environment
crashes, with the send/don't send box. what can be the reason for this?
it's quite annoying coz it happens everytime a change is made (practically
every 5 mins!). I spend my time making backups and restoring rather than
coding!

I have access 2k3 pro with the latest updates installed (ver 11.5614.5703)

Thanks,
Jef
 
Jeffrey Ah-Chong said:
I have an application developed in access 2003, which loads custom
libraries(also in access 2k3). The problem is that everytime a library is
modified (a property/function/ whatever) then the development environment
crashes, with the send/don't send box. what can be the reason for this?
it's quite annoying coz it happens everytime a change is made (practically
every 5 mins!). I spend my time making backups and restoring rather than
coding!
Click to expand...

I don't know the exact problem but using MS Access add-ins has always
been a bit touchy. One thing you could consider doing is to delete
and create the references to the add-ins each time you make changes to
the backend.

You can also programmatically work with the references so you can put
all this logic in a routine you run as required.

Dim ref As Reference
Set ref = References.AddFromFile(strFileName)

and

Dim ref As Reference

' Enumerate through References collection.
For Each ref In References
' Check IsBroken property.
If ref.IsBroken = False Then
Debug.Print "Name: ", ref.Name
Debug.Print "FullPath: ", ref.FullPath
Debug.Print "Version: ", ref.Major & "." & ref.Minor
Else
Debug.Print "GUIDs of broken references:"
Debug.Print ref.GUID
EndIf

Next ref

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top