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

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

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Trent" <(E-Mail Removed)> wrote in message news:e8DbW$(E-Mail Removed)...
> 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
>
>

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.

"Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Try holding down the Shift key when you open the form. That should prevent
Item_Open code from running.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Trent" <(E-Mail Removed)> wrote in message
news:e8DbW$(E-Mail Removed)...
> 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
>
>

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.

"Sue Mosher [MVP-Outlook]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Try holding down the Shift key when you open the form. That should prevent
Item_Open code from running.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Trent" <(E-Mail Removed)> wrote in message
news:e8DbW$(E-Mail Removed)...
> 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
>
>