Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 2007 Error

Posted on 2012-03-18
5
Medium Priority
?
204 Views
Last Modified: 2012-08-14
Hi,

When I try to run a macro SETPROPERTY to set Visible = 0 on a control  I get an error as follows:

"A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control."  It then goes on to say I need to restart the OLE server outside of Microsoft Access.

This macro ran fine previously.  Now it chooses to fail for no reason.  The macro runs and it only fails with this error when it attempts to run the SETPROPERTY line.  Other commands prior to the SETPROPERTY run fine.  Tried rebooting but no luck.

Help is appreciated.
Charlie
0
Comment
Question by:cwbarrett
[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
5 Comments
 
LVL 21
ID: 37736378
First, do you nave  at least  Office 2007 SP2 update installed. If not, be sure to do that. It will resolve lots of issues. This may help: Where is the About dialog for Office 2007 applications?



Also try compacting your database.
0
 

Author Comment

by:cwbarrett
ID: 37736394
I reverted to a backup copy from yesterday.  It works.  I've noticed that Access 2007 is quirky.  Just when you think it's fine something throws it for a loop.

Just to see if it helped I compacted the bad copy and it didn't help.  I thought maybe the OLE/ActiveX server was a service but couldn't find it.

It looks like the version of Access is SP3.

Thank you.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37738418
<I've noticed that Access 2007 is quirky.>
...Unfortunately , you could say that about any application...

Perhaps moving away from macros and instead using VBA would go a long way in resolving this perceived "quirkiness"?

;-)

JeffCoachman
0
 

Author Comment

by:cwbarrett
ID: 37738492
I agree.  Any suggestions for books on beginner VBA?

Charlie
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 37738797
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

609 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