Re: Linked access database
I have been using the linked Access database NBNData.mdb with Recorder 6, running on Microsoft SQL Server 2005 Express Edition, without any problems until the last few days, but now the link seems to have been broken. The error message is:
Connection failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I have tried setting up a new Access Project to link to the R6 database but that fails with a similar error, SQL Server does not exist or access denied.
Nothing has changed on my system over the last few weeks except that windows update has recently installed Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 (KB955706). The microsoft website list several known problems with SP3 but none that seem at all relevant to this problem.
I'm baffled, but I really need to get this working again quickly. Any suggestions?
Janet
British Lichen Society