Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page