Solved

MS Access Reference

Posted on 2011-03-03
4
289 Views
Last Modified: 2012-08-13
I had this old ACCESS 97 mdb thrown at me and I want to do with it is look at the reports and extract the queries. When I open the mdb I get this message about invalid reference. It is in regards to this element called GSELib.mde. This mde is sitting in the same folder as the mdb. I know almost nothing about MS Access.  How do I resolve this invalid reference? I am using MS Access 2007 and I told it not to convert the database.
Public Function UserSetReferences()
Dim ref As Reference, thispath, LibName As String, FoundLib As Boolean
On Error GoTo ErrorProcessing
thispath = CurrentDb.name
i = 0
Do Until trash = "\"
    i = i + 1
    filepath = Left(thispath, Len(thispath) - i)
    trash = Right$(filepath, 1)
Loop
PathCrntMDB = filepath
ChDir filepath
'GSEAcctng.mda
Set ref = References.AddFromFile(filepath & "GSELib.mde")
ExitFunction:
Exit Function

ErrorProcessing:
DoCmd.SetWarnings True
DoCmd.Hourglass False
If Err.Number = 32813 Then Resume Next

UserErrRoutine Application.CurrentObjectName
Resume ExitFunction
End Function

Open in new window

0
Comment
Question by:rwheeler23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 35027583
Try adding the reference manually.
Open the VBE (visual basic editor) - with the mdb file open in Access key Alt + F11
In the VBE choose References from the Tools menu
Click Browse
In the Files of type: drop down select MDE
Browse to the directory where the mde file is located and select it

Any errors?
OM Gang
0
 

Author Comment

by:rwheeler23
ID: 35027940
Once I got past the message about stopping the debugger I can at least see the tables. My problem now finding the query he used to populate one of the tables. I think he was hiding the actual code in and mde file and when I try to open the mde file, MS Access 2007 tells me it cannot convert and mde file.
0
 
LVL 28

Expert Comment

by:omgang
ID: 35028161
The mde file was created from an mdb.  The conversion to mde would have removed any readable code when it was compiled.  Any chance finding the original mdb file?
OM Gang
0
 

Author Comment

by:rwheeler23
ID: 35028185
Let me see if I can pull this guy out of retirement.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question