MS Access 2007

Posted on 2015-01-06
Medium Priority
Last Modified: 2015-01-06
I have transferred an "MS Access 2007" application to a new PC that has  Window Professional 7 and MS Access 2010 installed, the same as where the application was.

None of my code is now working, I suspect I need some sort update but have had no luck trying to source it on the net.
Question by:Brogrim
  • 2
LVL 11

Expert Comment

ID: 40533297
Does you Access 2007 application has calendars?

The Microsoft Calendar control (mscal.ocx) has been completely removed from Access 2010. They also suggests that users consider the Date Picker control as an alternative.

Author Comment

ID: 40533331
There are no calendars in the application, just as you suggested Date Picker is been used. I have compiled again but still no code working behind my command buttons.
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 40533341
did you setup your Trusted Locations?
File > Options > Trust center > Trust center settings > Trusted Locations

is your db located in the trusted location?

Author Closing Comment

ID: 40533512
Rey, thanks for the suggestion, I have checked the trusted location and my 2010 file is not there. what is there is and address

C:\Program Files (x86)\Microsoft Office\Office14\ACCWIZ\

As suggested I added the trusted location and it has worked.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

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