Windows 7 and Access 2003

Discussion in 'Access Configuration' started by Jonathan, Jun 4, 2010.

  1. Jonathan

    Jonathan Guest

    Hi, running an Access 2003 application the runs on WindowsXP and not Windows
    7.

    error 3035 system resource exceeded
    error 2004 there isn't enough memory to perform this operation. Close
    unneeded programs and try the operation again.

    This occurs when navigating a complex tab form with 180,000 records.

    As this application runs in WindowsXP on the same machine, is there a
    setting in Windows7 that is somehow restricting Access?

    Any ideas appreciated :)

    Many thanks,
    Jonathan
     
    Jonathan, Jun 4, 2010
    #1
    1. Advertisements

  2. Why would anyone ever do that? No user can ever comprehend 180K
    records at once.

    You need to change the tab form to load only the records the user is
    working with at the moment. That could be 1 or a few dozen records,
    but binding to the whole table is a rookie mistake -- granted, one
    that is encouraged by the Access sample databases, but a mistake,
    nonetheless.
     
    David W. Fenton, Jun 4, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.