server to Secure Access Database

hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.
]
any idea?I've got a very similar problem.
I can access my data perfectly without jet security but when I secure my dat
abase it won't accept any username or password.
I have ensured that I am using the correct workgroup security file by modify
ing the servers registry (HKLM/Software/Microsoft/Jet/4.0/Engines/SystemDB)
and verified that the server is in fact using that particular file by swappi
ng it with the default syst
em.mdb.
It accepts @.rmtuser='Admin', @.rmtpassword='' when I am using the default sys
tem.mdb and have reinstated admin's 'open database' permission.
TIA
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...