how much memory

Discussion in 'Hardware' started by dirtyh, Mar 27, 2004.

  1. dirtyh

    dirtyh Bit Poster

    Hello all been a while but still read the forums.
    Anyway does anyone know how much memory is needed to open a 500m/b database Access i think.
    At the moment my freinds pc with 512 memory wont open this,as he's ordered a new pc from me should i put in one or two g/b of memory.

    He will be useing it mainly for running scripts and web design.

    any ideas are welcome

    thanks harry
  2. Phoenix
    Honorary Member

    Phoenix 53656e696f7220 4d6f64

    personally 2gb is overkill if thats your only reason for getting it
    im not entirely sure why you cant open the file with 512mb
    i can open gig access files with 512mb of memory
    and had no problem with anything with a gig

    512mb should open the file no problems
    1gb is standard for anything heavy these days though, so i'd go with that anyway
    Certifications: MCSE, MCITP, VCP
    WIP: > 0
  3. Japes

    Japes Bit Poster

    Sounds more like the DB was created for use with an older version of Access (ie Access97 or 2000 and he's using Office/Access XP) rather than there being anything wrong with the hardware.

    Was a conversion of the DB done?

    Try the following

    Open explorer find the file and make a backup copy of the file (shouldn't be needed but always worth being safer than sorry)

    Goto Tools drop down menu in Access
    select: Database utilities
    select: Convert Database
    select: To current ........
    Find the original MDB file and let it do its thing

  4. tripwire45
    Honorary Member

    tripwire45 Zettabyte Poster

    I tend to agree with the consensus...512 megs of ram should be plenty. Sounds like either an incompatibility with the application or a corrupted file.
    Certifications: A+ and Network+
  5. Luton Bee

    Luton Bee Kilobyte Poster

    Without wishing to denegrate Japes's idea, I would recommend you try this on a backup copy of the .mdb file first as you may find it doesn't open in the later version of Access either and conversion tends to be one way only.
    Certifications: MCSE, MCSA, MCP, A+, Network+ C&G ICT

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.