+ Reply to Thread
Results 1 to 8 of 8

Creating picture database, how to and what to use?

  1. #1
    Registered User
    Join Date
    07-17-2019
    Location
    London
    MS-Off Ver
    365
    Posts
    1

    Creating picture database, how to and what to use?

    Hi All!

    Hope you're well.
    I am looking to create a database that will store pictures from clinical cases and also boxes that contain a description of the pictures. Each case may have multiple photographs attached. I want this to be a searchable database. This will eventually be used as a training tool at the hospital and for personal use. The ability to attach links / documents to each case would also be helpful.

    Though I am new to creating databases, I am a quick learner and can pick up things if guided.

    I have a few questions:
    - Is it possible?
    - What software would be most suitable? Excel? Access?

    Any information / tips / guidance points would be much appreciated.

    Thanks!

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,210

    Re: Creating picture database, how to and what to use?

    You'd use access rather than Excel. You probably wouldn't store the actual pictures in the database, you'd store them on a shared drive and then store the location of them in your database tables.

    If you haven't built a relational database before, you'll need to do a bit of reading up before you start anything - there's a good introduction in the pdf of the first post here: https://forums.aspfree.com/microsoft...es-208217.html

    I've attached a copy of it.

    From what you've described, you'll need at least 2 tables.
    Attached Files Attached Files

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,533

    Re: Creating picture database, how to and what to use?

    Definitely Access - I have moved the thread accordingly.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Creating picture database, how to and what to use?

    MS Access, MS SQL Express, MySQL.
    Any of these can do the job.
    While it is possible to build using Excel... anything beyond very rudimentary data store (along with path/link to image) is going to be more work than what it's worth.

    But you'll need to evaluate best fit solution based on your need and what tools you pick as front-end.

    For an example, if you want to make this db/tool available outside of internal network (i.e. accessible from public network).
    You will need to go with MySQL or SQL Server (not Express) + web application (ASP .NET, php, etc) to serve as front-end.

    There are many open source software/cheap software out there that may serve your need better.

    Ex:
    OpenKM - Open source document management system
    SharePoint - If you have Enterprise SKU for Office 365 you may already have this. SharePoint uses MS SQL Server as backend and has robust search algorithm along with document store and workflow.
    ďProgress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.Ē
    ― Robert A. Heinlein

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,210

    Re: Creating picture database, how to and what to use?

    Out of interest, why not express?

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Creating picture database, how to and what to use?

    No server agent and can't use jobs I've had to deal with this at my work. While there are workarounds it's not ideal.

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,210

    Re: Creating picture database, how to and what to use?

    I'd forgotten about that, it's been a long time since I used express.

    If they're considering access though, I'd say that agent jobs will be pretty far down the list of requirements!

  8. #8
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Creating picture database, how to and what to use?

    If they're considering access though, I'd say that agent jobs will be pretty far down the list of requirements!
    Ah, true.

    As a side note, if you add linked server, you'd want server agent as well.
    Otherwise, it's going to be a headache, as SQL service will stop any time there's issue with query to linked server. :p

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] creating a database from existing database by user choice
    By almostgenius in forum Excel General
    Replies: 5
    Last Post: 05-29-2015, 05:29 PM
  2. Creating macro to insert a picture by including specific picture name & path
    By NissaFrenchRamsteyn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:40 AM
  3. Replies: 3
    Last Post: 10-24-2012, 08:15 PM
  4. Excel Picture Database
    By sonskyn in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-29-2007, 05:32 AM
  5. Excel Picture Database
    By sonskyn in forum Excel General
    Replies: 1
    Last Post: 08-28-2007, 11:19 AM
  6. Can EXCEL show the picture from the database ?
    By worldapart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2006, 01:15 PM
  7. Picture Database
    By sparx in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 10:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1