Access Project Connection Problem

I have several projects that have been working for at least four
years. Last Thursday, the connections for these projects began
dropping immediately upon opening the project. When I test the
connection, the connection will succeed. However, upon closing the
connection dialog box, the database temporarily connects and then
drops. This happens for both Access 2k and Access 2003. I spent
Thursday and Friday trying to get things back to the way they should
be, with no success.

Has anyone ever seen this before? If so, is it correctable? Finally,
how?

Thanks in advance.

Re: Access Project Connection Problem

I can only think of 2 things which could cause this,
- The network link keeps dropping, at which Access will hault transactions
until restarted.
- Someone is accessing the database with a Vista operating system, which
makes modifications to the database references that are not backwards
compatible.

I'd suggest trying to record when these occur and see if it correlates to a
user logging in or when the network stops working.


wrote in message
news:b64378c8-893d-4df9-b788-cf61f323b754@21g2000hsj.googleg roups.com...
>I have several projects that have been working for at least four
> years. Last Thursday, the connections for these projects began
> dropping immediately upon opening the project. When I test the
> connection, the connection will succeed. However, upon closing the
> connection dialog box, the database temporarily connects and then
> drops. This happens for both Access 2k and Access 2003. I spent
> Thursday and Friday trying to get things back to the way they should
> be, with no success.
>
> Has anyone ever seen this before? If so, is it correctable? Finally,
> how?
>
> Thanks in advance.

Re: Access Project Connection Problem

> I can only think of 2 things which could cause this,
> - The network link keeps dropping, at which Access will hault transactions
> until restarted.

That would seem like what is happening. But why would my laptop start
halting transactions that used to work fine. I think it has to be
some kind of driver issue. Maybe MDAC has been corrupted or
something.

> - Someone is accessing the database with a Vista operating system, which
> makes modifications to the database references that are not backwards
> compatible.

It's not this. We do not use Vista and I can use access from
workstations to access the database. It is specifically a problem
with my laptop.


> I'd suggest trying to record when these occur and see if it correlates to a
> user logging in or when the network stops working.

I've looked at the log. It shows a connection and an immediate
disconnect. It does not give a reason for the disconnect.