access 2003 free memory problem

[JOCOPVA]

i try to open up microsoft access 2003 and i get an error message it reads
A system error occurred, or there isnt enough free memory to start. Close unneeded programs and tyry again.

I have done all the updates for thge prgram please help

[puppydogbuddy]

You did not provide much information about the database size, the operating environment that your database is running in, whether you do a compact&repair on a regular basis, etc. Memory problems could result from any number of practices and procedures that are followed in the operation of your database. Here are a few things to check:

1. make sure name autocorrect is turned off....this is known to cause problems
http://allenbrowne.com/bug-03.html

2. if you haven't done so, your mdb needs to be compacted and repaired on a regular basis.

3. make sure you have applied the latest service pack available for your version of Access http://support.microsoft.com/sp

4. failing to explicitly close recordset objects that you have opened in various procedure subs.

5.failing to close automation objects that you have opened in your
code.

6. if the fixes discussed above do not work, your db could be corrupted and you should proceed accordingly. See the following links:

http://allenbrowne.com/recover.html

http://allenbrowne.com/ser-47.html

http://allenbrowne.com/ser-25.html