Access - Linked Servers

[Gary Phillips]

Hi

we have some Access databases that are password protected. I get an error when I try an access these through a Linked Server. If I remove the password there is no problem.

I have tried adding the password to the security Information with a user of admin but this fails with a 7303 error. Should I not use admin as the user ??

Any ideas ???

thanks

Gary

[Al Gill]

Can you tell me what settings you used for the linked server setup? I want to access an Access database via query analyzer but don't know the setup syntax.

Thanks,

Al

[MAK]

--OpenRowset
select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\Jimmys\Jimmys.mdb';'admin';'', [Warehouse location])

[MAK]

--Linked server

EXEC sp_addlinkedserver
@server = 'MyAccess',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\Jimmys\Jimmys.mdb'
go

select * from openquery(MyAccess,'Select * from [warehouse location]')

[MAK]

--opendatasource
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Jimmys\Jimmys.mdb";User ID=Admin;Password=;')...[Warehouse location]