MS Access adp to SQL 2000 connection failure
Posted on 2006-07-04
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?