473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Lost References in one copy?

Hello and thanks! I have an A2k mdb that suddenly lost its reference to
Microsoft Office 9.0 Object Library, yet the backup and a developement copy
have not lost the same reference (all copies reside on the same machine). I
do not have an explanation; how can i keep this from happening again? The
database has not been compliled (no modules, just subs contained in the
forms).

--
Regards,

Eric J Owens
AT&T Business Services/MasterCard LCM Team
ej*********************@att.com
Nov 13 '05 #1
1 1636
> Hello and thanks! I have an A2k mdb that suddenly lost its reference to
Microsoft Office 9.0 Object Library, yet the backup and a developement copy have not lost the same reference (all copies reside on the same machine). I do not have an explanation; how can i keep this from happening again? The
database has not been compliled (no modules, just subs contained in the
forms).


References can be curious things. I've had problems when a user with an
older version of Access tries to open a database shipped with references
specific to a newer version (e.g. 2002/2003). I keep this code on hand for
checking references, which may help, though I can't say I know why a
reference would disappear.

Public Function ReferenceInfo() As String
'run in the immediate window:
'?ReferenceInfo
On Error Resume Next
Dim r As Integer
Dim strMessage As String
Dim strTitle As String
Dim refItem As Reference
For Each refItem In References
If refItem.IsBroken Then
strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath
Else
strMessage = "Reference: " & refItem.Name & vbCrLf _
& "Location: " & refItem.FullPath & vbCrLf
End If
r = r + 1
Debug.Print strMessage & " Total References = " & r; ""
Next refItem
End Function
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hugoski | last post by:
Hi... Our company has a fairly large client-server application and is very complex in its construction. The main point about that is there are a number of separate client pieces that require...
4
by: Andrew | last post by:
Can someone help explain the following? Why is it that elements 5 - 9 in Bar::group do not seem to resolve to elements 0 - 4 of Bar::group when de-referenced? If I am following this correctly...
5
by: lkrubner | last post by:
Is it true that Javascript has no clone() method, to pass an object by copy of value instead of reference? If I have an object and want to make an array out of all of its instance variables, I...
2
by: Kathie | last post by:
I have an application that I distribute as an MDE file that clients run within Access. One of my clients has Win2000 and Office 2000 and recently installed Office SP3. Now they are getting VBA...
2
by: Colleyville Alan | last post by:
I am using Access and have embedded the ActiveX control Formula One that came with Office 2000. (ver 3.04). I have created and formatted a spreadsheet and now I want to copy the info with...
3
by: SD | last post by:
Hi, I have been struggling with this problem for two days. My development PC is running Windows XP/Office 97. The work stations are running Windows 2000/Office 97. In the past I have always...
1
by: Claire | last post by:
In our application we've used several 3rd party windows form controls that were installed into their own individual directories. We have to avoid using the GAC, all our dlls should be found...
7
by: blangela | last post by:
What does the default assignment operator (compiler supplied assignment operator, sometimes also referred to as the implicit assignment operator or the synthesized assignment operator) do when the...
14
by: Philipp Reif | last post by:
Hi all, I've got a little hole in my head concerning references. Here's what I'm trying to do: I'm calling a function, passing the reference of a business object for editing. The function clones...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.