1. Want to see less ads, private areas and be able to post? Register Today to receive all these benefits and more!
Dismiss Notice

Want to see less ads, post content and the ability to buy & sell Oakleys?

Register Today or Login

  1. HoakleyRobb

    HoakleyRobb Oakley Enthusiast Premium Member

    Messages:
    48
    Trophy Points:
    128
    For folks with sizable collections, how do you keep them documented? Is there a good (inexpensive) tool that can be used for this? Thanks.
     
    Shade Station Oakley Sunglasses

    Register to Not see this ad
  2. OakleyFrankFMJ

    OakleyFrankFMJ The Legend - - Vlad the Impaler Premium Member Lifetime Member

    Messages:
    26,887
    Trophy Points:
    2,993
    Excel spreadsheet comes to mind.
     
    kronin323 likes this.
  3. Ramslacrosse09

    Ramslacrosse09 Oakley Enthusiast Premium Member Lifetime Member

    Messages:
    451
    Trophy Points:
    203
    also o-review is a great place
     
  4. Oakley G

    Oakley G Oakley Enthusiast

    Messages:
    340
    Trophy Points:
    153
    Yep O Review is the best for that.
     
  5. Carrera1963

    Carrera1963 Lover of Juliet Premium Member

    Messages:
    3,535
    Trophy Points:
    743
    Excel works fine.
     
    OakleyFrankFMJ and kronin323 like this.
  6. kronin323

    kronin323 Font of Useless Knowledge Premium Member

    Messages:
    16,746
    Trophy Points:
    2,993
    I know o-review can be used to catalog your collection, but can you keep it private or is the only option for it to be public?

    If you want to use true database SW, MS Access is the MS Office solution. There's also MS SQL Server Express, and MySQL Database Server.

    But for this job my first choice would be what others have mentioned, Excel. The only reason to use a real DB is if you're recording a lot of details about each item and really want to dig deep in specific custom queries, and you know SQL...

    You can still do that with Excel, though, if you know how to use it properly.
     
    OakleyFrankFMJ likes this.
  7. kronin323

    kronin323 Font of Useless Knowledge Premium Member

    Messages:
    16,746
    Trophy Points:
    2,993
    My favorite SQL query joke has always been:

    SELECT * FROM users WHERE clue > 0

    0 rows returned...

    (It's only funny if you know some SQL...)
     
  8. Oakley G

    Oakley G Oakley Enthusiast

    Messages:
    340
    Trophy Points:
    153
    I used to use Excel and then ultimately Access before discovering the O Review. It's ok as long as there's no issues with your hard drive or you don't use your jump drive, etc. Data retrieval is expensive and a pain around these parts. That's why I always recommend the O Review first and call it the best option for collectors, since you can access it remotely, you can enter pictures into it much more readily than other DB's, you can download it as an Excel file (well, .csv file anyway), amongst other benefits. But you are right, Excel or Access works fine if you want a no frills option.
     
    Last edited: 5/8/15