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?
AnsariRemove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:
>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?
>Ansari
>