Search results for query: *

Does anyone know of any way to run Microsoft Access as a service? I have a large Access DB (read-only data mart) that is being accessed in 2-tier by users running Access linking to those tables. Obviously, there is a lot of network traffic. Is there any way to run Access as a service locally...

We have a MSTR 7.2.2 implementation with MD in Oracle 9i. For our change control process, we create dev MDs in Access using project duplication. We then OM the new and modified objects into the production MD using 3-tier to 3-tier and 7.2.2 OM. This has always worked before. We are doing a...

I'm using the 7.2.2 IServer API in a VB project and I can't figure out how to disconnect from the project and server (3-tier). I connect by instantiating a DSSDataSourceEnumerator for the project sources, then getting a reference to the DSSDataSource for the server. I init the server. I then...

FYI to the community, I've created a new forum on Tek-Tips named "Microstrategy Developers Group". It is a member moderated forum, which means that it is not subject to the same restrictions that the pure technical forums are. The forum is for discussing: "Best practices...

Please excuse me if this question is simple, but I am a newb to such things. There is a client/server application which requires TCP/IP connections from the client to an app server thru port 34952. Unfortunately, the app server is behind a firewall. Corporate security refuses to punch a hole...

This is a simple question, but I am new to Java. I am prototyping an application in java using a standard 3-tier design. I'd like the application layer to retrieve data from the data layer via ResultSet objects that get passed back from the data layer. In Visual Basic, this is...

I have an Acer CD-RW 20x10x40x. It can't write but can still read. I'm not sure where to begin diagnosing the problem. Would someone please give me some pointers so I can get started? Thank you all very much for your help.

I have a fact named "Number of Days" which contains the number of days in a given period on a Time lookup table. I want to create a metric on this fact that simply gives me the total number of days in a period. If the report contains: Attribute: Year Metric: Number of Days Filter...

I am on a quest to make custom column names more descriptive to help SQL debugging. I have custom columns in my project and I don't know what attributes/facts use them. I see them appear on the list. When I try to delete it, it gives me an "object in use" error. How do I find out...

My ACER CDRW stopped recording. It can still play CDs just fine, but during the recording process, I always get an "Insert blank media" message, even though a blank CD is in the drive. I have tried a whole bunch of different CDs with no luck. I have tried ahead Nero, Roxio, and...

Please excuse me if this is a simple question. I'm a newbie. I'm an AT&T Broadband customer in the MA region. My house has multiple PC connections thru a Linksys router, but I don't have a home network set up. Of the 3 PCs connected, one doesn't connect to the Internet thru IE. It is...

I need to build a metric that takes the output of another metric at a given attribute level, then assigns a score based on the tier it falls in. Example: Total Revenue at the Customer level If Rev >= 75000, then 12 Elseif Rev >=25000, then 10 Elseif Rev >=10000, then 8 ... Else 0 End If What...

How do I test whether or not a method can be called on a particular COM+ object? I am creating a COM+ application to support an intranet web site. I would like to enable/disable buttons and hyperlinks on the site based on the user's security settings. However, I don't want to use any...

How do I copy a worksheet to a different (existing) workbook? The Copy method of the worksheet object throws an "Out of bounds" error when I try to pass in a reference to a sheet in a different book.

I want to execute a stored procedure using the ADO command object and get a disconnected recordset. How can I do this? I don't want to build a SQL string which calls the stored procedure, because I have to be able to retrieve the output values of the parameters. It has to be a command object...

I'm using VB6 SP5. How do I check the caller of a function passed nothing into a ParamArray? Is there any special syntax? What is the underlying data type of the ParamArray? I know that the array is passed in byref... does this have any effect?

This is my first COM+ application, so please be gentle. I created two ActiveX dlls for use in a COM+ application. The first is a business component and the second is a db component... pretty standard stuff. I make extensive use of the ObjectContext and SecurityProperty objects, so I can't...

In a VB app using an in-process DLL, Err.Raise seems pretty straightforward. The Err.Raise line creates an error that propagates up the call stack to find a space with error handling enabled. To be truly safe, a class using Err.Raise to communicate errors should release all references to...

I have tried every possible version of INSERT statement and can't find anything. Please help!

I have a component registered in COM+ that doesn't support transactions. It performs database-read operations with ADO. Can I call: Set cn = New ADODB.Connection or do I have to: Set cn = CreateObject("ADODB.Connection") The connection is to a SQL Server 7. I know SQL Server will...