Solved

Database window Not Visible in Access 97

Posted on 2009-07-02
26
361 Views
Last Modified: 2012-08-14
I hope someone can help me with this.

I was just contacted by a client that's using an app that uses Access 97 as a back end. The front end app is a compiled application.

Someone on site did "something" and now, when you launch the back end file,  the 97 database window is no longer visible. In fact it doesn't even appear as if a database is open. But a lock file is created when you open the file. And the lock file disappears when you close it.

I imported all the data, which did in fact exist, into a new clean 97 database and rename the new table to the name the front end app is looking for. Everything worked fine. Then the user started getting error messages about entry being required. And so we had to go back to the old app. the one with no database window. And their front end works fine.

Holding the shift key down doesn't seem to do anything. F11, F12 nothing.

Any ideas??? It's been a long time since I used 97 and I don't remember the ins and outs.

Thanks,
E
0
Comment
Question by:eantar
  • 6
  • 5
  • 5
  • +4
26 Comments
 
LVL 75
ID: 24767589
Can you get to the menu bar?  If so, Tools>>Startup ... check Display Database Window, etc.

?

mx
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24767639
ckick Windows, Unhide and select the mdb name
0
 
LVL 2

Expert Comment

by:bgrandjean
ID: 24767657
If you can get to the menu bar try Windows - Unhide
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 39

Expert Comment

by:thenelson
ID: 24767700
Open the buck end with shift bypass. Press F11 . Goto tools, startup. Check the Display database window checkbox.

add an autoexec macro that opens a message box that says " you don't have Access to this database! and then closes it. That way users  would have a harder time screwing it up. (The shift bypass will get past the macro).
0
 
LVL 4

Expert Comment

by:Nicolaze
ID: 24771635
Did you try to press the shift key and keep it pressed while opening the database?
0
 
LVL 5

Author Comment

by:eantar
ID: 24772945
Hi all, thanks for your comments.

I've tried all things suggested. I've tried bypassing the start up by holding the shift key down. I've tried F11. I've tried looking at start up under tools. I've tried unhiding the window.

Nothing seems to work and still no database window. Even the menu items that would appear don't appear. Yet, when the front end is loaded a lock appears. When it closes the lock disappears. When I import to another Access 97 db, I can import all the tables and the queries.

This is pretty bizarre and frustrating. Any other ideas???

E
0
 
LVL 2

Expert Comment

by:bgrandjean
ID: 24773186
Are you opening it with the runtime version instead of the full version of Access?  If you are double clicking the mdb/mde and default program has changed to the runtime version this could happen.  Open Access 97 first then open the mdb.
0
 
LVL 75
ID: 24773476
"When I import to another Access 97 db, I can import all the tables and the queries."

So, isn't that the solution? I was just going to suggest that.

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24773716
eantar,

Check your scroll bars, it may be just scrolled off the screen.

JeffCoachman
untitled1.JPG
untitled2.JPG
0
 
LVL 75
ID: 24773741
Good one Jeff!!  I was almost ready to think of that myself, LOL.  I'll bet that's it !!!!

mx
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24774001
Hi Jeff:  OK, you've peaked my interest - what do you use to make your 'cartoons?  I understand the screen capture, but the text balloons?
0
 
LVL 5

Author Comment

by:eantar
ID: 24774289
Thanks guys. I thought I did check that. Give me till next week as I can only access the client remotely and they are away till next week.

Thanks again,
Eddie
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24774815
Ray,

I copy the screenshot to MS Word and add the Text Ballons from the Drawing Toolbar.
The I take a screenshot of that, and paste to MS Paint and save as a jpg.

I could probably buy a screen capture progarm that does this though...

Jeff
0
 
LVL 5

Author Comment

by:eantar
ID: 24889553
Hi guys, my client has been on vacation so haven't had a chance to deal with this. If nothing happens soon I'll distribute the points.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24890248
Jeff:  Quick Screen Capture V 3.0 from http://www.etrusoft.com/
Cap003.jpg
0
 
LVL 39

Expert Comment

by:thenelson
ID: 24890301
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24890400
That would be great if I could read your hand-writing ;-)
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24891344
Or we could start an infinite loop and end up here again...

untitled.JPG
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24895650
I give!
0
 
LVL 5

Accepted Solution

by:
eantar earned 0 total points
ID: 25694638
This client resolved there own issue.
0
 
LVL 75
ID: 25695248
"This client resolved there own issue."

And *what* was ... the resolution ??

mx
0
 
LVL 2

Expert Comment

by:bgrandjean
ID: 25695264
So what did it turn out was the problem?  How did they fix it?
0
 
LVL 5

Author Comment

by:eantar
ID: 25696195
Hi guys, sorry to sound so mysterious on this. Here's the situation. This was a one time questions from the company that subcontracts me out. I was asked to see if I could help. I used this forum to try and get some ideas to this puzzling questions. Most of the suggestions on this thread I had tried but to no avail. Then, when I called the client back to continue the process, I kept getting voice mail without returned calls. so I considered the issue dead.

That's the story.

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 25697155
<I kept getting voice mail without returned calls.>
Did you get paid anyway?
;-)
0
 
LVL 5

Author Comment

by:eantar
ID: 25697306
Yes. That much did happen.

Anyway, upon inquiring about how to handle these issues on this forum I was told by a moderator to NEVER award points unless I've gotten a clear answer and resolution.

Thanks,
E
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 25697530
<I was told by a moderator to NEVER award points unless I've gotten a clear answer and resolution>
That is correct.

The reason is that many people search here, and if you "Accept" a post that is not an answer, it will be confusing to them.

   "There will always be another Question"

;-)

Jeff
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Ms Access VBA Variables 6 28
Access report groups with sums 5 28
Obtaining Access 2013 Runtime file for Sagekey 2013 Installer 3 19
Binding recordsets to a form 6 26
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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