Solved

Reference Error in Access 2010

Posted on 2014-03-18
8
290 Views
Last Modified: 2014-03-18
I encountered this error and posted a prior question on EE.  Here is the link

My previous EE question on this error

Rather than explaining everything again please refer to the prior question.

The suggestion I received and accepted were to add the MS Office reference and make sure that the entire Office suite was installed on the machine.

I finally got back to the client.  I discovered that the MS Office 14.0 reference was already present and that the entire MS 2010 Office suite was installed on the machine.

I am still getting exactly the same error.  Any other ideas?
0
Comment
Question by:mlcktmguy
  • 5
  • 3
8 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39937442
possibly 32/64 bit Office?
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39937523
We had had issues with 64 bit Access with some earlier client upgrades, so I verified that they were using the 32 bit version of Access.
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39937534
does the problem occur on all machines, or just one? (and are we sure the 64-bit version was never installed on the problem machine?)
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Author Comment

by:mlcktmguy
ID: 39937554
There is only one machine set up to test the upgrade, the rest are still running Office/Access 2003.
I didn't do the install so I am not 100 percent sure 64 bit was never installed on the machine, prior to 32 bit being installed.  Is there any way that can be verified?
0
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 total points
ID: 39937558
not sure
you could check folders e.g.
C:\Program Files (x86)\Microsoft Office\OFFICE14
and
C:\Program Files\Microsoft Office\OFFICE14

the latter is the 64-bit path
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39937606
I asked the client and they said 64 bit was never installed and mentioned that the machine would not even support 64 bit.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39937732
Thanks you very much for researching this, it was getting frustrating.  I saw you post in the old question but I've already awarded the points on that one.

I'll award the points on this question but point anyone looking for a solution to the old question.
0
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39937743
For anyone researching this issue for a solution.  Coachmen99 posted the correct answer but it is on the old question.  Please refer there for the solution ( a link is in my first post above) .  The short answer is that this function is no longer supported in Access 2010 but there is a work around
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hit enter key to run macro 13 23
Normalization of a table 19 74
Migrating Macro Menu’s From Access 2003 to Access 2013 2 32
Access Delete Query Not Working 13 30
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

778 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