Search results

Okay, brief overview. We currently have 2 MDE front ends to and oracle box. Database is about 25Gigs and have been minimising the traffic by optimising the queries. However we have always noticed some very strange problems now that our user base is about 150. They seem to become more apparent...

This is either tough or very simple. I have an array of record primary keys that need compiling in a report. The reason I have done this is access tries to download the whole table if I run a query! So I have created a report that has the control sources listed as a function that returns the...

Firstly the reason I am doing this is I have already got the data in arrays so there is no need to query the server again. Another reason is that the previous code was performing really badly and seemed to be downloading whole tables to query them from the server. This was taking in excess of...