Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access 2007 Error

Posted on 2012-03-18
5
Medium Priority
?
208 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
  • 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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

587 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