MS Access adp to SQL 2000 connection failure

Im working with Win 2003 Server, SQL Server 2000 (all on the server) and my client machine is Win XP as a client - has SQL client tools and MS Access 2000. I have an adp linked to SQL server. All working fine. Network is new.

So I opened the adp file and made some (very minor) adjustments, when I tried to close and save, the write failed. Came up with a message about "Delay write failure  Event ID 26 Failure of hardware or network connection" This in turn creates an file named adp1 whilst trying to write? When i tried to re-open this adp file (which is still and adp file) the error message is "adp file not correct format for Microsoft Access Project"

We've just set up this network and noticed that the connection to the server keeps dropping. This is possibly the problem, could anyone point me in the direction to analyse the set up for the connection?
LVL 5
Donnaa5dcpProject managerAsked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
Closed, 250 points refunded.
Netminder
Site Admin
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
What kind of event happen when the ADP initializes...Have you changed providers?
0
 
Donnaa5dcpProject managerAuthor Commented:
No event when the adp initialises. Just that error msg. I have no provider, its a stand alone network
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
what do you mean by stand alone network?
0
 
Donnaa5dcpProject managerAuthor Commented:
There is the server, the wire and 3 client machines.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
If the applications are on the client machines, I do not see how you could not be using a provider? How does the client application call the server?
0
 
Donnaa5dcpProject managerAuthor Commented:
This is not done over the Internet. I have the application SQL Server 200 here. I installed it on the server myself.The provider, if you like it the organisation, which is fibre optic linked.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Oh I got it ;)

I am not refering to provider as internet provider but the logical provider that regulates exchange between you client apps and server (ODBC, OLEDB, SQL Native...)
0
 
nmcdermaidCommented:
I believe ADPs' only use OLEDB connections. When you intially configure an ADP it uses the OLEDB driver and you enter the connection stuff, just like a UDL file but you don't get to pick the provider.

Was this ADP file on the server or on the local workstation when it crashed?
0
 
Donnaa5dcpProject managerAuthor Commented:
Ive solved it. Its the properties on the network card. I unticked "allow to disconnect if idle" box. Simple one really
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.