Cannot get into custom form due to data errors.

[Trent]

Hi,
We have an old Outlook form application that ties into an Access database.
The system was replaced by a web based version but the old version was
occasionally used to look at historical data.

Apparently the database the form ties into was moved to a new location. Now
when we try to open the form we get an error stating that the form could not
be opened due to data access errors.
I have tried opening the form in design mode by using Tools/Forms/Design a
form and then browsing to it but I get the same error.

Is this error caused by the database no longer being in the same location or
is this a data access error getting the form from the exchange server?
If it is just the database is there any way to get this form open so that
the database path can be updated?

We are running Exchange server 2000. Clients are using a mix of Outlook
2000 SP3 and Outlook 2003.

I would have thought opening the form in design mode should work without
trying to establish a connection to the database which is what makes me
wonder if it is an Exchange server problem.

TIA.
Trent

 

[Sue Mosher [MVP-Outlook]]

Try holding down the Shift key when you open the form. That should prevent Item_Open code from running.

 

[Trent]

That did it thanks.
I would have thought that opening it in design mode would prevent the code
from executing also but apparently it did not.

The new problem is that the form is password protected when I try to get
into design view. This was written by a former employee about 6 years ago
and has not been here for 3 years, not sure if we have documentation around
containing the password or not..

Can an Exchange administrator override these passwords or are we out of
luck?

Thanks for the help.

Try holding down the Shift key when you open the form. That should prevent
Item_Open code from running.

 

[Trent]

I got the password.
Found out that it was a simple lookup and got it through a macro. I was
right, this was written in 1999.

Thanks.

Try holding down the Shift key when you open the form. That should prevent
Item_Open code from running.