Access 97 application - where is the DB connection defined?

[Sielah]

I support an Access 97 application that has unfortunately just developed database connectivity problems.

This application uses data from its own tables, but also draws in data from an external Oracle database. The user has a connection to the Oracle database defined in their System DSN list.

For some reason, the application cannot connect to the Oracle database. When the user clicks on certain buttons, it displays a database login dialog. It accepts the user name and password we provide, but does not store them.

I've had about 5 minutes of training on this app, and have to solve the problem ASAP, so apologies for the stupid questions.

Where in the application would the user name and password to be used when connecting to the external Oracle database be stored? The settings are not in the System DSN - this has only the database name.

Being a VB programmer, I looked for the nearest code module, but there are no modules in this application - only tables, reports, queries and forms.

I have been able to open the offending form in design mode, but can't for the life of me find any kind of event handler or code that would show me exactly what happens when the user clicks on the button.

Any advice?

 

[cmmrfrds]

Go to Linked Table Manager under the Tools Menu and relink the Oracle tables. This time make sure the save password option is checked.

 

[Sielah]

The menu options displayed are File, Window and Help. None of them contain an option relating to Table Linking.

Would the visibility of menu options be controlled by local permissions or user access rights?

 

[JerryKlmns]

If you could get to the Immediate window (Ctrl + G), type these one at a time and hit enter

CurrentDb.Properties("AllowFullMenus") = True
CurrentDb.Properties("AllowShortcutMenus") = True
CurrentDb.Properties("StartupShowDBWindow") = True
CurrentDb.Properties("StartupShowStatusBar") = True
CurrentDb.Properties("AllowBuiltInToolbars") = True
CurrentDb.Properties("AllowToolbarChanges") = True
CurrentDb.Properties("AllowSpecialKeys") = True
CurrentDb.Properties("AllowBypassKey") = True
CurrentDb.Properties("AllowBreakIntoCode") = True

Ignore errors if the property is not found.

Try this on a copy of the file