Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Access 2007 only "Home" visible

Hi,

I got a mdb file and need to update the logic behind. It is in the access 2000 format. When I open it in Access 2007 it opens in the run mode. I cannot open the design view.

How can I get it into design mode? Is there a brief introduction in Access2007 anywhere?

Thanks in advance
0
HugoHiasl
Asked:
HugoHiasl
3 Solutions
 
Dale FyeCommented:
 It sounds like there is a startup form or macro, and you may be able to bypass this by holding down the Shift key until the application is loaded.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you cannot open it via the Shift Key Bypass suggested by fyed, then you may be dealing with a .accde or .accdr file.

If it's an .accde file then you're out of luck - this is the "compiled" version of Access. You wouldn't be able to open these in Design view

If it is an .accdr file (the "runtime" format), you may be able to just change that extension to "accdb" and open it. You might still have to use the Shift Key trick.

0
 
Jeffrey CoachmanCommented:
<Is there a brief introduction in Access2007 anywhere?>
Is this a separate question?

You can lean the basics of MS Access from books like this:

http://www.amazon.com/Microsoft-Office-Access-2007-Step/dp/0735623031/ref=sr_1_1?ie=UTF8&qid=1300891696&sr=8-1

http://www.amazon.com/Microsoft-Office-Access-Plain-Simple/dp/0735622922/ref=sr_1_11?ie=UTF8&qid=1300891696&sr=8-11

JeffCoachman
0
 
HugoHiaslAuthor Commented:
Thanks to all.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now