Search results for query: *

Hi Allyne, I'm currently having the same problem you described. However, my SP is a SELECT statement. I tried using the same statement in a view. I still get different results every time I run it. I tried recompiling the SP. It did not work. Were you able to find a solution to this problem...

Thanks guys, however, with regular stored procedures, I have no problems with Crystal. The error comes out when I use temporary tables within the stored procedure. Any ideas?

Is it possible to use a stored procedure (that creates a Global Temporary Table, populates it and at the end select all its content) as a data source for Crystal Reports? I get an error stating that no rowset was returned when I try to add the SP as a record source in Crysal. Yet, it executes...

I have an access DB being accessed by a VB application. This system is to be distributed to users. Is there a way to protect the DB so that only the users with that VB application can access the DB. Otherwise, anybody with Access installed can use the DB.

Thanks Krisman,<br><br>This is not however what I was asking. Let me try to rephrase. In my access report page setup - column tab, I've selected to print 3 columns with the &quot;down then across&quot; layout. My report has 5 fields layed out vertically so that access prints the first column...

Hi,<br><br>I'm trying to setup an access report that has 3 columns and one level grouping. I've set the option &quot;Keep together with first detail&quot; for that group. Because of this setting, the columns are not always vertically aligned and this is a must. Any ideas on how to implement such...