Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    4

    Exclamation Unanswered: Access, SQL or Oracle?

    I just started working for a company that has several Access databases - A total of 7 gigabytes of Access files that are linked to raw data files. The raw data files come from different departments and must be run through Access queries to format them correctly. There are also links between the Access databases, and it gets very confusing.

    My boss wants me to improve the system and include on-line reporting for about 50 internal people. He would like for the reports to be interactive with dropdowns and radio buttons. I am an expert VBA programmer for Excel, and could build this type of report without a problem, but have no clue how to get this on a website. I am willing to learn a new reporting software, if it would work better on-line and more seamlessly with a database. Perhaps Access Data Pages or SQL Reporting might be better.

    What backend database do you recommend, and what do you recommend for the on-line reporting?

    Thanks,
    Pahla

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm a lazy bum, not willing to do more work than necessary to get the results that I need. Especially for this size job, I'd suggest SQL Server 2000, with SQL Server 2000 Reporting Services. Quick and easy to code, basic funcionality is almost automatic, with nearly unlimited customizability. Best of all, it is easy to exchange documents between SQL Server, Excel, Access, DBF, flat-files, and just about anything else that does either OLE or ODBC.

    -PatP

  3. #3
    Join Date
    Oct 2005
    Posts
    4
    Do you think I'll be able to do this all on my own - or do teams of people usually do this?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You'll need to learn the tools, but once you have basic familiarity with them I would think that one person could do this relatively easily.

    -PatP

Posting Permissions

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