Recent content by marcboorman

decompiled and recomplied okay, did what the link described and it has increased the size of my mdb file to 6.8MB. This isnt so bad but will this fix the MDE file from bloating? thanks marc

thanks for the reply Not sure if I mentioned but the autoshut down procedures that I have included force the MDE file to compact back to normal size, But this only happens when every single user has logged out. It seems that because there is always at least one user logged in it wont ever...

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...

more detail the query that I would have to run would be very complex and beyond my capabilities. As the queries have already stored the information on open forms througout the project I decided to just put them into an array and store them as strings locally. However the reason I don't want...

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...