By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Convert Access 2003 To Access 2007

P: 4
I have created a Database in Access 2003 and have now downloaded 2007. I have tried converting it in several ways. I have opened my previous Database and saved it as a 2007 verion -No success, I have created a Blank 2007 DB and imported all the table , Queries , Forms Reports and Macros from the previous version. Although I can see all - The switchboard which is suppose to open immediately only opens with No information. I can only see my Background with the Logo and One Button with no information. Please help. The switchboard Form and table is still there. I have tried to recreate the Macros. I went into the Switchboard Manager and everything looks OK . The Actual Switchboard is not opening up properly. I have no idea what to do
Nov 18 '08 #1
Share this Question
Share on Google+
5 Replies

P: 23
I would suggest leaving it it the 2003 format. I am assuming that you have not gone into the trust center and changed the Macro security. To do that click the office button (round button in top left), click access options then click on trust center, click the trust center settings button, click macro settings, change it to enable all macros. Hope that will help you out.
Nov 18 '08 #2

Expert 2.5K+
P: 3,532
Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location, and Switchboards from 2003 backwards are driven by VBA code, not Macros..

To trust your folder, click:

Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

Welcome to Bytes!

Linq ;0)>
Nov 18 '08 #3

P: 4
Thanks A Lot I Did BOTH suggestions and It Is Now Working
Nov 19 '08 #4

Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Nov 19 '08 #5

P: 1
thank you very helpful :)) missinglinq
Oct 5 '15 #6

Post your reply

Sign in to post your reply or Sign up for a free account.