Problems Access .LDB ???

[pldelosrios]

I have a customer with an Access connected with an SQL Server Db.
The problem (i suppose) is that ALL USERS ARE USING THE SAME .MDB (exactly the same file, not a copy!!!)
After some weeks of normal use, progressively, the connection Access-SQL Server failed.
Today, they can open the Access DB. but when some register is requested the connection Access-SQL Server
fails.

I think the problem comes from overloading of the ldb. Is it possible?
Or maybe is problem of the DSN or MDAC?
Or some question of SQL Server maintenance?

 

[fluteplr]

have a customer with an Access connected with an SQL Server Db.
The problem (i suppose) is that ALL USERS ARE USING THE SAME .MDB (exactly the same file, not a copy!!!)

Should not be a problem.

After some weeks of normal use, progressively, the connection Access-SQL Server failed.
Today, they can open the Access DB. but when some register is requested the connection Access-SQL Server
fails.

AND the error message WAS???????

I think the problem comes from overloading of the ldb. Is it possible?

Probably Not.


Or maybe is problem of the DSN or MDAC?

Could be, see above.

Or some question of SQL Server maintenance?

Or someone changed the password.

 

[pldelosrios]

'When i try to open a linked table i see this error message:

*******************************************************************
'Error in connection:
'SQL State: '01000'
'SQL Server Error 10110
' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())

'Error in connection:
'SQL State: '08001'
'SQL Server Error 6
' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]the specified SQL Server is not found
*******************************************************************

' But when i open the NT Explorer i can see the server!!!