How to setup replication between access to SQL Server , MSDE inste

Hi Karen.
Yes it is possible to have Access subscribers:
see http://msdn.microsoft.com/library/en...lctem_0815.asp
And the Access DBs should be subscribers and the SQL server would be the
Publisher.
And YES switch to the MSDE instead of Access, for a lot of reasons.
(Compatibility, flexibility, openness in regard to debugging and error
logging, stability)
HTH
JorgenD.
"Karen Middleton" wrote:

> Hello All
> We have a computer based application running on trucks and they
> capture the transaction into a Access database we need to collect the
> data from multiple trucks into a SQL Server database centrally.
> Can somebody please explain whether Access can replicate to SQL Server
> with Access as publisher and SQL Server as the subscriber. Also, I am
> wondering is it worthwhile to replace Access by MSDE since MSDE is
> free I would appreciate your feedback on this count.
> Also, any books, web sites, white papers and how to setup a
> replication from Access to SQL Server. Also, can somebody please
> explain how the replication works from Access to SQL Server and is it
> lot of coding to get this working and what kind of replication is it
> full table or delta replication.
> Also, some of our trucks will be in far off places is there a nice way
> in which Access can be made to replicate from these remote sites to
> the central site what kind of comms do we need.
>
> Many thanks in advance for your inputs
> Thanks
> Karen
>
Karen,
I agree with Jorgen that MSDE would be preferable long-term. However, your
original question was about having Access as a publisher and SQL Server as a
subscriber, which is not available out of the box using Jet. If you have sql
server as a merge publisher and access as a subscriber, in many senses
datawise it will be functionally equivalent, but care will need taking with
administrtion and conflict resolution where the role of the publisher is
indeed distinct to the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
sql

How to setup replication between access to SQL Server , MSDE inste

Hi Karen.
Yes it is possible to have Access subscribers:
see http://msdn.microsoft.com/library/en...lctem_0815.asp
And the Access DBs should be subscribers and the SQL server would be the
Publisher.
And YES switch to the MSDE instead of Access, for a lot of reasons.
(Compatibility, flexibility, openness in regard to debugging and error
logging, stability)
HTH
JorgenD.
"Karen Middleton" wrote:

> Hello All
> We have a computer based application running on trucks and they
> capture the transaction into a Access database we need to collect the
> data from multiple trucks into a SQL Server database centrally.
> Can somebody please explain whether Access can replicate to SQL Server
> with Access as publisher and SQL Server as the subscriber. Also, I am
> wondering is it worthwhile to replace Access by MSDE since MSDE is
> free I would appreciate your feedback on this count.
> Also, any books, web sites, white papers and how to setup a
> replication from Access to SQL Server. Also, can somebody please
> explain how the replication works from Access to SQL Server and is it
> lot of coding to get this working and what kind of replication is it
> full table or delta replication.
> Also, some of our trucks will be in far off places is there a nice way
> in which Access can be made to replicate from these remote sites to
> the central site what kind of comms do we need.
>
> Many thanks in advance for your inputs
> Thanks
> Karen
>
Karen,
I agree with Jorgen that MSDE would be preferable long-term. However, your
original question was about having Access as a publisher and SQL Server as a
subscriber, which is not available out of the box using Jet. If you have sql
server as a merge publisher and access as a subscriber, in many senses
datawise it will be functionally equivalent, but care will need taking with
administrtion and conflict resolution where the role of the publisher is
indeed distinct to the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]

How to set celldata and Permissions to Role

Hi All,

I know how to create a role and adding Members(users) to that role by using AMO class library,but i need some sample code like how we can set the database permissions to the role and how we can set the celldata to that particular role.If any one knows about this please send reply immediately.

it is very urgent.

Thanks in advance.

Hi,

I believe the Adventure Works sample AMO application has code for creating permissions (search for CubePermission or DimensionPermission in the code):

http://msdn2.microsoft.com/en-us/library/ms160736.aspx

In general, you can use this 'reverse engineering' trick to get AMO code:

- create the objects you want with the user interface (in BI Development Studio with wizard/editors or in SQL Management Studio); in this case, use the security dialog to setup the database/dimensions/cubes permissions

- then look at the XML: in BI Development Studio, right click on the cube item -> View Code and search for the CubePermission XML fragment to see the CubePermission, similar for DimensionPermission; in SQL Management you can right click on the cube, script Alter or Create, and then find the CubePermission XML fragment

- to be easier to read, copy the CubePermission in a separate file

- there is a 1-to-1 relationship between the AMO classes and properties and the XML, by reading the XML you will know what classes and properties to set; for example, the <CubePermission> element tells you to create in AMO a CubePermission object; the <Name> sub-element corresponds to the Name property

Adrian Dumitrascu

How to set a link whitch opens the record in an new Window

Hello NG,
I have to link to a SharePoint Document library out of the Report. But the
Library opens in the Report Window and not in an new Window.
How can I set the Link in Reporting Services that the Library will open in a
new Window?
Thanks
ThomasThis is for a regular report (not SharePoint) but hopefully it will put you
in the right direction. You need RS 2000 SP1 or greater (which hopefully is
everybody at this point).
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"','_blank'))"
Couple of things to notice. First, I use the Globals!ReportServerURL so I do
not hard code the server name. Second, be careful with the single and double
quotes.
Note that the Jump to URL action is used for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
> Hello NG,
> I have to link to a SharePoint Document library out of the Report. But the
> Library opens in the Report Window and not in an new Window.
> How can I set the Link in Reporting Services that the Library will open in
> a new Window?
> Thanks
> Thomas
>|||Hello, thank you for your Answer.
I try it many times, but it wont work. The Report doesn't identify it as a
Link.
I build it like this.
="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
But there must be an Mistake in it. Have I forgot something?
Thanks
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
> This is for a regular report (not SharePoint) but hopefully it will put
> you in the right direction. You need RS 2000 SP1 or greater (which
> hopefully is everybody at this point).
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "','_blank'))"
> Couple of things to notice. First, I use the Globals!ReportServerURL so I
> do not hard code the server name. Second, be careful with the single and
> double quotes.
> Note that the Jump to URL action is used for this.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>|||You are piecing together a string. Yours is a total mess. Look closely at
mine. You are doing the same thing.
For instance, what is the apersand doing here? Appersand means to append two
string. You do not have two strings to append. You are putting an appersand
in the middle of a string. You have done that same throughout this.
="javascript:void(window.open('http://serveradress&"/
I suggest you first hard code the value (get it working with out the Field
values.
I don't know if this will work but it is a whole lot closer:
="javascript:void(window.open('http://serveradress/" &
Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
> Hello, thank you for your Answer.
> I try it many times, but it wont work. The Report doesn't identify it as a
> Link.
> I build it like this.
> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
> But there must be an Mistake in it. Have I forgot something?
> Thanks
> Thomas
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so I
>> do not hard code the server name. Second, be careful with the single and
>> double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>>
>|||Ok I did it like you. Now the Report identyfies it as a link. But when i
click at the link nothing will happen. If I copy the link into the Internet
Explorer, nothing will happens too.
Thats the generated link.
javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
If I take the middle of this link
'http://servername:port/wss_id/default.aspx than its working.
Maybe its because of the Internet Options?
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
> You are piecing together a string. Yours is a total mess. Look closely at
> mine. You are doing the same thing.
> For instance, what is the apersand doing here? Appersand means to append
> two string. You do not have two strings to append. You are putting an
> appersand in the middle of a string. You have done that same throughout
> this.
> ="javascript:void(window.open('http://serveradress&"/
>
> I suggest you first hard code the value (get it working with out the Field
> values.
> I don't know if this will work but it is a whole lot closer:
> ="javascript:void(window.open('http://serveradress/" &
> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it as
>> a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so
>> I do not hard code the server name. Second, be careful with the single
>> and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will open
>> in a new Window?
>> Thanks
>> Thomas
>>
>>
>|||What is this about? You don't want to have a // after javascript.
javascript://void
As I mentioned previously, I do not know about sharepoint integration.
However, I don't think it will make any difference.
Do the following, put what I have below in the jump to URL action and make
sure this works as advertised. This pulls up the google page in another
window:
="javascript:void(window.open('http://www.google.com/','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Thomas Burger" <thomas.burger@.nospam.de> wrote in message
news:uCiNm7UfIHA.1900@.TK2MSFTNGP02.phx.gbl...
> Ok I did it like you. Now the Report identyfies it as a link. But when i
> click at the link nothing will happen. If I copy the link into the
> Internet Explorer, nothing will happens too.
> Thats the generated link.
> javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
> If I take the middle of this link
> 'http://servername:port/wss_id/default.aspx than its working.
> Maybe its because of the Internet Options?
> Thomas
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
> news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
>> You are piecing together a string. Yours is a total mess. Look closely at
>> mine. You are doing the same thing.
>> For instance, what is the apersand doing here? Appersand means to append
>> two string. You do not have two strings to append. You are putting an
>> appersand in the middle of a string. You have done that same throughout
>> this.
>> ="javascript:void(window.open('http://serveradress&"/
>>
>> I suggest you first hard code the value (get it working with out the
>> Field values.
>> I don't know if this will work but it is a whole lot closer:
>> ="javascript:void(window.open('http://serveradress/" &
>> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it as
>> a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will put
>> you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL so
>> I do not hard code the server name. Second, be careful with the single
>> and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report. But
>> the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will
>> open in a new Window?
>> Thanks
>> Thomas
>>
>>
>>
>|||I took your link into the Jump to Url action. But its the same Problem.
When I click at the Link nothing will happen.
Is there any other alternative without javascript to open in a new Window?
Thomas
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:OIAzHiVfIHA.5900@.TK2MSFTNGP02.phx.gbl...
> What is this about? You don't want to have a // after javascript.
> javascript://void
> As I mentioned previously, I do not know about sharepoint integration.
> However, I don't think it will make any difference.
> Do the following, put what I have below in the jump to URL action and make
> sure this works as advertised. This pulls up the google page in another
> window:
> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
> news:uCiNm7UfIHA.1900@.TK2MSFTNGP02.phx.gbl...
>> Ok I did it like you. Now the Report identyfies it as a link. But when i
>> click at the link nothing will happen. If I copy the link into the
>> Internet Explorer, nothing will happens too.
>> Thats the generated link.
>> javascript://void(window.open('http://servername:port/wss_id/default.aspx'))
>> If I take the middle of this link
>> 'http://servername:port/wss_id/default.aspx than its working.
>> Maybe its because of the Internet Options?
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:uzvWj3TfIHA.4728@.TK2MSFTNGP03.phx.gbl...
>> You are piecing together a string. Yours is a total mess. Look closely
>> at mine. You are doing the same thing.
>> For instance, what is the apersand doing here? Appersand means to append
>> two string. You do not have two strings to append. You are putting an
>> appersand in the middle of a string. You have done that same throughout
>> this.
>> ="javascript:void(window.open('http://serveradress&"/
>>
>> I suggest you first hard code the value (get it working with out the
>> Field values.
>> I don't know if this will work but it is a whole lot closer:
>> ="javascript:void(window.open('http://serveradress/" &
>> Fields!new_wss_id.Value.ToString() & "/default.aspx'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:%23T5dHrTfIHA.5164@.TK2MSFTNGP03.phx.gbl...
>> Hello, thank you for your Answer.
>> I try it many times, but it wont work. The Report doesn't identify it
>> as a Link.
>> I build it like this.
>> ="javascript:void(window.open('http://serveradress&"/"&Fields!new_wss_id.Value.ToString()&"/"default.aspx"+"'))"
>> But there must be an Mistake in it. Have I forgot something?
>> Thanks
>> Thomas
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
>> news:%23AX%23YeueIHA.5160@.TK2MSFTNGP05.phx.gbl...
>> This is for a regular report (not SharePoint) but hopefully it will
>> put you in the right direction. You need RS 2000 SP1 or greater (which
>> hopefully is everybody at this point).
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "','_blank'))"
>> Couple of things to notice. First, I use the Globals!ReportServerURL
>> so I do not hard code the server name. Second, be careful with the
>> single and double quotes.
>> Note that the Jump to URL action is used for this.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Thomas Burger" <thomas.burger@.nospam.de> wrote in message
>> news:upw1MZueIHA.5788@.TK2MSFTNGP02.phx.gbl...
>> Hello NG,
>> I have to link to a SharePoint Document library out of the Report.
>> But the Library opens in the Report Window and not in an new Window.
>> How can I set the Link in Reporting Services that the Library will
>> open in a new Window?
>> Thanks
>> Thomas
>>
>>
>>
>>
>