I am evaluating the sql server 2000 and have problem when using the linked
server to connect the Access database.
The tstaccess.mdb using database password without spesific userID and
password. I mean that I just set the database password, and leave the
userID = Admin password = null.
File tstaccess.mdb located in folder sharedir. The folder "sharedir" in
"testserver" has been set for sharing, with paramater for Everyone, full
control.
Following the sql guide, I set the linked server option in Enterprise
Manager as follow:
On general tab
Linked Server = TestLinked
Provider name = Microsoft Jet 4.0 OLEDB Provider
product name = OLE DB Provider for Jet
datasource = \\testserver\sharedir\tstaccess.mdb
provider string
On security tab
selected Be made without using a security context
On server options tab
selected: Data access, RPC, use remote collation
When click OK, the linked server added to the list. But when accessing
tables I got this message:
"Error 7399: OLEDB provider 'Microsoft.Jet.OLEDB.4.0' reported an error."
I knew its probably becouse the database password, but I dont know how to
include the parameter to the linked server options, how to type it
correctly, and where I should put it ?
Could anyone that have the similar case and the solution for it to help me
with this problem ??? Please.
Thanks in advance.
Regards,
Sun