Connection keeps dropping never happened before
Hi all I have a question, we have been entering data into a database that has sQL Server 2005 in the background and Access 2007 on the front end for over a year. We connect to it by entering in our user name and password. its not windows authentiction its mixed mode. but for some reason the connection keeps dropping. This happened right after we lost internet (cox cable had an outage) after that we cant seem to stay connected to the database and i dont understand why. SQL Server is on a Server the clients open Access on their pcs then log in with user name and password. they link to sql throught the Data Link Properties of Access 2007.
can anyone help please