Re: FN-FORUM MS Access help required

date posted 1st May 2002 10:30

One of these might be it:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q248910

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q236977

Make sure you have applied sp1 for Office 2k

One thing to check is to make sure that you explicitly release all object
variables in code. Any object that you 'Set' in code should be set to
'Nothing' when you've finished with it.

Also check swap file isn't 100% full.

If the app was converted from 97, it often helps to export everything into a
new (unconverted) Access 2k app.

Kathy
http://www.vendetta.co.uk

----- Original Message -----
From: "Martin Akehurst" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, May 01, 2002 9:47 AM
Subject: FN-FORUM MS Access help required


> Doing a job for a client on MS Access 2000 under Win98SE. I'm constantly
> getting 'Out of memory' messages. The files are not particularly big.
> I've tried the 'compress and fix database' without any luck. I've
> reinstalled Access 2000.
>
> The only option appears to be to do a restart in Win98SE and (usually)
> delete the query or form and start again.
>
> Any suggestions?
>
> Thanks folks
> Martin Akehurst
>
> ==================================================================
> = Saffas: we design, host & maintain websites. =
> = Hosting from £10 per year. Design from £150 with free hosting. =
> = Why pay more for less? Visit us at http://www.saffas.com =
> ==================================================================
>
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>