Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-08 : 14:59:43
|
Paul writes "Hi,
I'm not sure if my problem relates to Microsoft Access97 or SQL Server 7.0. But as the error I'm getting is being issued by the SQL server, I am making that my first port of call.
I have trawled through various knowledge bases and Microsoft Technet, but I am unable to find anything that resembles my problem.
I have Access97 databases installed on my NT workstations, these databases contain linked SQL server 7.0 tables on a Windows NT 4.0 Server (stand alone). All sitting on a 100baseT Ethernet LAN.
Everything has been humming along nicely for about twelve months, but recently the workstations are getting an ODBC error stating that an update on a linked table failed and I have to stop and start the SQLserver service to correct the problem every few hours. These errors occur when users try to run update queries that are stored in the access database itself on the workstation. I have tried SQL Pass through queries to send the query straight to the server but this makes no difference.
I have checked out current activity in enterprise manager while this is all happening and there are no locks occuring. There is a daily maintenance plan that re-indexes and re-pages and attempts to repair any minor errors. The network is fine because you can still view the data with select queries no problem, also I can update data in other databases on the same SQL server.
The problem is intermittent which is always the most worrying thing, but tells me that permissions to the table are not involved.
I have now run out of ideas, so I'm posting this request in the hope someone might be able to point me in the right direction.
Regards,
Paul." |
|
|
|
|
|
Update on a SQL linked table fails