Results 1 to 14 of 14
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Nixa, Missouri, USA
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Viewing Access without Access

    Howdy all. I have a unique? problem. I have several people that need to view Access files over our LAN. They do not need to manipulate data. Does Access have a Viewer like PowerPoint does. No, buying copies is not an option. The data is in Access 97.
    Your time is greatly appreciated.

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    Micorsoft makes a scaled down version of Access called Access Runtime. It basically alows users to enter, view, edit, and delete records, and generate reports. It does not allow them access to the tables, queries, and other items found in the full version.

    We use this quite extensively in througout out company as there is no licensing issues as to how many PC's can have it installed, etc. If your company bought very many full version of Access then chances are there was a copy or two of the Runtime version available. Check with your Information Systems group.

    I will caution you though that there are some items that may work in the full version which may not work in the Runtime version. If you use the Switchboard Manager to generate switchboards based on "options" stored in a table, you may have probles. I have had this happen a couple of times where I had to switch the commands over to VB driven. One other item that will not work is the "Filter by Form" capability. There is documentation in the MS Developer Web site that can assist you with this problem. Search for article Q172090.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Viewing Access without Access

    The distributable runtime is available ONLY with the developer's edition. Other versions of Office 97 do not include it.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Nixa, Missouri, USA
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    So This brings me back to square one? No viewer unless I buy Developers?

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    Do your users need to view something other than reports? You can save Access reports in snapshot format, and the snapshot viewer is free. The snapshots will be static (i.e. you'll need to recreate them every time you want new information in them).

  6. #6
    roon
    Guest

    Re: Viewing Access without Access

    I also have this problem where users want to include reports and forms from my system in Powerpoint slide shows. The problem I have is how do you embed these as simple images within Powerpoint. Any help much appreciated. I know you can use the free snapshot viewer but it only works with reports not with forms.

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    have you tried a screen capture of the form or report

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Nixa, Missouri, USA
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    Sorry but snapshot wont work, I do not have enough time to create updates snap shots multiple times a day for multiple people.

  9. #9
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    Sounds like you're stuck with having to ask the powers that be to pony up the cash for a Developer's edition of Office. Act quickly before you can't find a retail version for Office 2000!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  10. #10
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    Or have someone develop some simple ASP pages to query your database and display the results on your company's intranet. But that's another thread for another forum!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Viewing Access without Access

    If that's the situation, you don't need the developer's edition because you would still be creating stuff constantly and that's what you want to avoid. It sounds like Shane's second recommendation on ASP is the only thing that will do what you want to do.

    Essentially, you want to allow people to see updated information on demand from an Access database without their having Access. That means that a browser-based solution is the only option you have.
    Charlotte

  12. #12
    ROON
    Guest

    Re: Viewing Access without Access

    Yes,
    The problem is when you press the print screen it captures the borders and menus as well, which doesn't look so good. If you could just do a printscreen and have it capture the report only then that would be what I want.
    Is it possible to make Access do a full screen like Pwerpoint or Adobe?

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Viewing Access without Access

    Once you wander into ASP or other browser-based solutions, it isn't Access that controls such stuff. You'll have to find an ASP artist to handle that for you. They should be able to control what prints and what doesn't.

    edited for afterthoughts
    What did you mean by PrintScreen? That copies the current window to the clipboard. If you used a web-based solution, your users would generally use the browser print button or a script-based print button on the page to print the page. Those results are controllable.
    Charlotte

  14. #14
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Viewing Access without Access

    i use a program called paint shop pro for screen captures
    you can get full screen or just capture areas of the screen
    you can down load a free evaluation copy off the internet

Posting Permissions

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