Error Sql-server express link to access database

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DBName" returned message "Unspecified error".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DBName".

 

Solution:http://support.microsoft.com/kb/814398

To work around this problem, follow these steps:

1. Log on to the computer by using the SQL Server start up account.
2. Create a folder named Temp in the operating system installation directory.
3. Permit full access to a non-administrator account on the Temp folder.
4. Set the value of the TEMP and TMP user variables of the SQL Server startup account to the newly created Temp folder. To do so, follow these steps:
   1. Right-click My Computer, and then click Properties.
   2. Click the Advanced tab, and then click Environmental Variables.
   3. In the User variables for Logon User list, click TEMP, and then click Edit.
   4. In theVariable Value box, type C:\Temp as the location of the new Temp folder, and then click OK.
   5. Repeat steps c and d to set the value of the TMP variable.
   6. Click OK two times.
5. Log off, and then log on to the computer by using SQL Server startup account.
6. Restart the SQL Server services.