1

Topic: It is not possible basis Access

Prompt as  basis Access
Problem in that that it is necessary to specify a file *.mdw (System Database)
In C# it is connected normally, here Connection String:
Provider=Microsoft. Jet. OLEDB.4.0; Data Source=d:\database\db_rezept.mdb; Jet OLEDB:System Database=d:\database\db_rezept.mdw; User Id=admin; Password=79240
Here so I create a linked server:
EXEC dbo.sp_addlinkedserver ' L7db ',
' AN OLE DB ',
' Microsoft. Jet. OLEDB.4.0 ',
' d:\database\db_rezept.mdb'
EXEC dbo.sp_addlinkedsrvlogin ' L7db ',
FALSE,
NULL,
' admin ',
' 79240'
And where to specify System Database in any way I will not understand, prompt please.

2

Re: It is not possible basis Access

Malkot wrote:

Here so I create a linked server:
EXEC dbo.sp_addlinkedserver ' L7db ',
' AN OLE DB ',
' Microsoft. Jet. OLEDB.4.0 ',
' d:\database\db_rezept.mdb '

and why at you ' an OLE DB ', instead of ' Access'?

3

Re: It is not possible basis Access

Changed on "Access", changed nothing

4

Re: It is not possible basis Access

So it is exact

5

Re: It is not possible basis Access

Microsoft. ACE.OLEDB.12.0 Installed, and with a file of working group it does not turn out in any way. Everywhere write type edit in the register, but at me such SystemDB is not present in the register and the more so it will be only for one basis and if I want  from other place?
There should be other output.