Recent content by WilsonM

Hi, The security in Analysis Services does not seem to work, I created a cube that as only one dimension (for testing), that dimension has 3 stores. I created a role that only lets the user see only 1 of 3 stores. When that user opens the cube he can still see all stores. Could anyone...

Thanks for the help ... you guys are great. Wilson

Hi Joanne, Thanks for the quick response and yes I would love to take a look at those urls. Thanks again, Wilson

Hi guys, I'm having some memory problems and it's not because I don't have enough RAM (I have 256 MB of RAM). Could anyone tell me if there is a way to release the memory or a function that would do the same. I already close my objects and set them to nothing after using them. ex...

Hi everyone, Here is my problem, I have to extract data from a Oracle database, process the data and then put the result in a Access table. While I'm running the necessary queries, I always get the same error: Instruction at "0x040ceeab" uses memory address...

Hi, How can I set the registry file so that when I use that ODBC file I don't have to put in my password every time I try to access some data. My ODBC driver is for Oracle version 8.00.05 I know that for the UserID I have to use the following syntax: UserID= "MyLoginName" I...

Hi, How can I set the registry file so that when I use that ODBC file I don't have to put in my password every time I try to access some data. My ODBC driver is for Oracle version 8.00.05 I know that for the UserID I have to use the following syntax: UserID= "MyLoginName" I...

Thank you very much Parthi.

Hi, I have a database that will be accessed by an excel file, my DB has a Password and I would like to know if it's possible to set that password in the code so that the user will not have to enter this password. Thanks in advance, Wilson

Thanks Omega

Hi, Can anyone just refresh my memory. What is the diff. between a View and a Table? Thanks in advance, Wilson

Did you try passing the SQL to a string variable and then set RecordSource. Whatch out for the syntax of SQL Server, I can't help you with this one but I know that in some cases you need to use some caracters on the where (#). Dim str as string str = "SELECT * FROM Pay WHERE PayDate >...

Do you have an email that I could send you something? If not here's the idea: Put the security file (.MDW) on the network. and create a shortcut that will open your DB and point to that (.MDW) file. Hope I could help, Wilson

Hi, If I'm not mistaking that function only have one arg. Try this: =Nz(Count(*), 0) Good luck,

It all depends on what others should be able to do with your database. If no one else should be able to do anything on your database then: Create a new user in the Admin group ex.: "Superuser" (make sure that you don't forget log name and your personal ID no) Remove the user...