Need to set up DB with API, considering SQL, need your expert advice

Discussion in 'Databases' started by Edmond Dantes, Sep 11, 2008.

  1. #1
    basically, we need to have a database where people can drop of files through an API into our system.

    so primarily we need a database/database server where people can drop of files through an API. We then need to have to be able to access this data at some point.

    secondly, we eventually want to have a secure public interface where people can run reports. but this is not a priority

    as i have some experience(years ago) with managing SQL database through MS access, i think that basically, it will take the following steps:

    get a Windows SQL database server
    hire somebody to set up the database/API on it
    once its working, use MS Access to pull the data that was put in through the API

    obviously, im new at this :) will the above work, what do i need to be careful with? any advice would be appreciated
     
    Edmond Dantes, Sep 11, 2008 IP