The First Thing to Disable in Access 2007
I have just started to play around with Access 2007 and so far my thoughts are indifferent. I am not sure how well the "Ribbon" is going to play out. I work in Access Databases a lot with my job and I am pretty comfortable with the way things have been. I have gotten used to the Ribbon in Word, Excel, and Outlook. In fact it seems to make those tasks more fun. I have been really holding off on Access though.
I have found the first thing you will want to disable in Access 2007. That is the annoying security on VBA Macros that are enabled by default.
Click Options when you try to open your first Database.
I know they are trying to protect less suspecting users here… but if you're familiar with Database management … there is NO reason for this to be enabled. Instead of just enabling the content, click on the "Open the Trust Center" hyperlink.
This brings you directly to the Macro Settings without having to navigate through Access Options. Enable all Macros .. click ok and be done with it!
Mysicgeek's Tech Lingo: Macro - In Access this is a series of tasks pulled together into one button click. For Example, you can have a macro query several tables or other queries to make a table with your desired results.
Daily Email Updates
You can get our how-to articles in your inbox each day for free. Just enter your name and email below:
The first thing I would do is uninstall this garbage. This is so…10 years ago.
Anyway to do this via Registry ?
I know — I wasn't sure how I felt about the ribbon, either, and I've only been using Access 2003 for about a year. It seems OK most of the time (you just have to know where things have moved to in the new Access). The problem I'm having is that "import Access database" seems to be disabled.
Hi,
I would like to know how to get rid of this Ribbon thingy altogether. I'd like to make a form for my clients and have it just show the FORM when they execute it. It's ridiculous for my clients to see any kind of structures to tables etc. etc.
Anyone know the answer to this question?
@jee:
You can minimize the Ribbon but there is not a way to get rid of it that I am aware of. Here is an article on how to minimize it:
http://www.howtogeek.com/howto/microsoft-office/maximize-space-by-auto-hiding-the-ribbon-in-office-2007/
sir,
i would like to thank you first and i have a question that : how can i remove the ribbon from access database by code