Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2012
    Posts
    9

    Database publish

    Hi ,

    I have created a database which has 2 tables that have been linked to an Excel sheet which is present in my local machine.
    Is there a way where I can publish my database such that people in my company can view the database without tampering with the data.
    NOTE: The excel sheet is present only in my system and they will not be having the excel sheet.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    store data in Access, publish in Excel...
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2012
    Posts
    9

    Red face

    Quote Originally Posted by healdem View Post
    store data in Access, publish in Excel...
    I need it in access cause I have created user friendly forms.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    which is fine, so store data in Access, NOT Excel (or any other spreadsheet for that matter).

    the problem is that you are doing the project arse about face.

    Spreadsheets are great for analysing data arranging it in a form that is easy to understand and read especially by accountants, but at bbest its dubious for storingdata, and at worst down right dangerous.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    So, your data is currently in MS Access?
    How volatile is the data? How often does it change? What kind of latency can users tolerate? Can they deal with data that is a day old, or do they have to be able to see up-to-the-minute changes?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    'erm at present some or all of the data is in Excel spreadsheets with some forms in Access
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Really???
    Then I concur with your assessment of the ass-vs-face arrangement.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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