Showing posts with label scenario. Show all posts
Showing posts with label scenario. Show all posts

Sunday, March 11, 2012

Access Update Query Problem

Looks like my suspicion was correct; in the join scenario, you're
dragging the complete recordset over and attempting to do the join
client side. If your data set is large (or your machine is
over-taxed), then it'll take a while to do the updates all at once.
In the second scenario (VBA), you're updating one record at a time on
the SQL Server, so the machine is not dealing with multiple records.
Does that make sense? As to how to fix it, not sure.
StuOn 7/29/2005 1:22 PM, Stu wrote:
> Looks like my suspicion was correct; in the join scenario, you're
> dragging the complete recordset over and attempting to do the join
> client side. If your data set is large (or your machine is
> over-taxed), then it'll take a while to do the updates all at once.
> In the second scenario (VBA), you're updating one record at a time on
> the SQL Server, so the machine is not dealing with multiple records.
> Does that make sense? As to how to fix it, not sure.
> Stu
>
In the join scenario, the msaccess process spikes the CPU but I/O is
stagnant. So I think there is a bug somewhere as the update join query
originally worked.
Dan|||On 8/1/2005 12:44 PM, Stu wrote:
> Which I/O? Disk or network? I don't think Access manages ODBC by
> writing it to a temporary file; I believe it tries to do it in-memory.
> I could be wrong about that.
>
Both.

Monday, February 13, 2012

Access is denied exception when loading an assembly from custom data processing extension

Hello,
I have been banging my head against this for the better part of today.
Here's the scenario. I have a custom data processing extension which
tries to make calls into another .NET assembly. As soon as this second
assembly is loaded, an "Access is denied: name_of_the_assembly"
System.Exception is thrown. I can't even catch this error as it seems
to occur on the assembly load and not on the first function call. Both
my data processing extension and second assembly have strong names and
are signed with the same key.
The rssvrpolicy.config is setup to allow FullTrust to my data
processing extension and second assembly. I have tried both URL
Membership Condtion as well as StrongName. Note that my custom data
processing extension works just fine if it doesn't call the second
assembly. Rolling everything back into a single assembly is not really
an option though.
OS: Windows Server 2003
Reporting Services SP1
IIS AppDomain Identity: NetworkService
Any ideas? Help please.
~JeffOk, I'm an idiot. It turns out that my data processing extension was
NOT signed but my second assembly was meaning that I had an untrusted
caller trying to call a trusted assembly and bomb! I went ahead and
signed everything and gave the proper StrongName membership in the
policy config and I'm good now.
I'm glad it turned out to be my problem because I couldn't figure out
for the life of me what I was doing wrong in regards to RS.
Hope this helps somebody else.
~Jeff

Access in AS Database

I have a scenario where I need to give access for one of my subordinate to the AS database on my AS Server. He should have the ADMIN rights to only that AS database. I cant give him rights to the Server box as it contains other AS databases too. Is it possible to give him such rights in AS 2000. so that he registers the server from any other machine and gets to see only that database. Also can we restrict his rights to cube level if we want to do so.

Thanks in Advance,
siaj

Hi,

You will need to create the database yourself (because this requires admin per server) and inside the database create a Role containing your subordinate account. Then, for that Role specify admin permissions for the database.

After this, the subordinate can connect to your server and he will be able to fill the database with dimensions, cubes, mining structures etc. However, he needs to be carefull to not delete that database Role (who contains him as member) or he will cut his access. Therefore, if the subordinate will use a BI project to deploy, he needs to make sure that the project contains the Role definition. If he will connect to the database to adminsiter it online, there shouldn't be problems.

Adrian Dumitrascu.