Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Unanswered: Best code for the job

    I am working on a project right now that is requiring a bit of dynamics. What i need to happen is when Client A logs into the website, he needs to be able to pull up document A, document B and document C from a menu. What i am wondering is what is the best/most efficient way to pull content from the access db to the documents for client A?

    Document A, B and C are all working correctly within the office. Displaying it on the website, whould i be better off using PHP and parsing the db info in or could i go XML and pull the clients info that way?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Not sure this is in the right forum.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I was thinking the same thing. How does your question relate to something you'd like to do in MSAccess?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if its a document then you are creating on the fly form an Access db then personally I'd send it either as RTF, or possibly PDF.

    The few dealing I've had with XML maek me want to avoid it.. but that probably has more to do with me not wanting to learn yet another (adjective deleted) interface language than it suitability

    I think a lot depends on what you expect your users to do with the document after the event.. if they need to edit and rework the document then you need to export the file in a suitable format. whether you do that as a HTTP request, a FTP request or send the file(s) by email is up to you. Im guessing int he modern world people will demand that the document must be available right now.... so that may well rule out an EMail event. You then get into potential problems of getting the data through a firewall.. some corporate firewalls are very very sniffy about DOC, PDF and other file types. Persoanlly Id use FTP, to avoid opening the document up in the web browser
    HTH

  5. #5
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    If you want to play with Microshafts ... sorry, Microsoft's formats, Access also can export to SNP files (snapshot). SNP is similar to PDF, it's a portable, uneditable format that reports export to that preserves format and content.

    Modern day browsers (IE anyway, don't know about Firefox) will open them if the user doesn't have the snapshot viewer (which is free btw). Chances of a corp firewall blocking SNP is less than PDF and much less than RTF and DOC.

    If you want to post the report result on-line, Access will also export to html, and you can format your report to look like a spreadsheet if you want.

    have fun,
    tc

Posting Permissions

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