Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

My Database is too big!!! Help.....

Discussion in 'Information Technology' started by Jurrasicway, Jul 28, 2006.

Tags:
  1. Jurrasicway

    Jurrasicway
    Expand Collapse
    Guest

    Hi,

    I have created a database that records visists to stores and also the Excel
    document/report completed at the visit is linked in an OLE field in each
    record. After linking/attaching 400 of these my database started to creak
    because it was 2GB. What is the best way to solve this problem? Does a
    hyperlink field take up as much space or is it better to split my databases?

    Any help would be much appreciated.
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004
    Sikh News How This Sikh Army Veteran Stood Out At Democratic National Convention - NDTV Breaking News Jul 30, 2016
    Sikh News Why This Sikh Cartoonist Is Sending A Postcard To Trump Every Day Breaking News Mar 23, 2016
    Ashdoc's Movie Review---fitoor Theatre, Movies & Cinema Feb 13, 2016

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    First make several copies of the database file, then build another database
    and move about half the data to it, then compact both of them.

    Now you can breathe.

    You can link the Excel files by simply storing the path to them. Have a look
    at my database DogMgr:

    http://www.datastrat.com/Download/DocMgr_2K.zip

    which will catalog the paths to Excel, Word, and text files. You can then
    limit the files by either changing the code, running a query, and/or
    deleting the data you don't want.

    You can use a hyperlink as shown by using a label as a hyperlink and
    grabbing the filepath with something simple like:

    Me![txtPath] = Me![FilePath] & Me![FileName]
    Me.lblPath.HyperlinkAddress = Me.txtPath

    After doing this, you'll find that your database is probably less than
    1/1000 the size.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Jurrasicway" <Jurrasicway@discussions.microsoft.com> wrote in message
    news:4861F929-C43A-46C5-8FAE-D1C38B0EAEBA@microsoft.com...
    > Hi,
    >
    > I have created a database that records visists to stores and also the

    Excel
    > document/report completed at the visit is linked in an OLE field in each
    > record. After linking/attaching 400 of these my database started to creak
    > because it was 2GB. What is the best way to solve this problem? Does a
    > hyperlink field take up as much space or is it better to split my

    databases?
    >
    > Any help would be much appreciated.
     

Share This Page