Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidhanson
Starting Member
1 Post |
 Posted - 2005-10-21 : 12:55:01
|
| i built a small db application with access 2003. i've completed my requirements - 4 tables, 4 queries, 2 forms with 3 sub-forms, 2 reports with 3 sub-reports and a couple of macro commands - to come up with my small db application.my problem is, i set the startup as hiding the db window, disallowing the use of special keys, short cuts, drop down menus, etc. in short, my db software now is like an executable file where i can't access the db window anymore and even the startup customization window.my question is, is there any way for me to retrieve the db window or even the startup customization window?i badly need to do some more adjustments and fine tuning to make my db app perfect. i hope there is.advance thanks! |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-21 : 13:47:05
|
| Well, that's a good lesson to keep a copy on hand that does not have any of those settings in place.Now, this MIGHT work... Open up Access directly (do NOT open it by double-clicking on your mdb). Browse through the open dialog box, find your MDB file and then hold down one of these keys (don't remember which one was the magic) SHIFT, or ALT or CTRL when you click on the OPEN button. Keep the key held down until the database opens completely. One of those used to be the magic "override default start options and display database window instead" key.---------------------------EmeraldCityDomains.com |
 |
|
|
wiltech
Yak Posting Veteran
51 Posts |
Posted - 2005-10-21 : 14:00:54
|
You might still be able to get into it using "secure.mdb", available from http://mvps.org/access/resources/downloads.htmquote:
From Terry Kreft. The Secure Database can be used to get access to and change the start-up properties of a secured database.
Tony W |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-21 : 14:04:37
|
| And since you haven't mentioned applying any passwords yet, you could just open a new blank Access database and import all the objects from your other one.---------------------------EmeraldCityDomains.com |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-21 : 14:22:00
|
| It's the LEFT SHIFT key -- try holding it down while opening it.Note that if you made it into an MDE file, then you are screwed if you didn't keep the original MDB file. |
|
|
|
|
|
|
|
|
How to show DB Window?