+ Post New Thread
Results 1 to 8 of 8
Windows Thread, Access wont create reports in Technical; Ok I have installed 5 computer suites this summer and bar a few permissions glitches with Delphi everything seemed to ...
  1. #1

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    19

    Access wont create reports

    Ok I have installed 5 computer suites this summer and bar a few permissions glitches with Delphi everything seemed to be working beautifuly. Until today.

    Access was deployed by GPO using the standard office install + a transform created using the office resource kit's little utility. There is also a GPO attched to the base workstation policy to restrict the universal file open dialogue and macros etc of office which applies to all 5 rooms and is being loaded and applied. However in the 3 rooms in question when you try to create a report in design view nothing happens no error no crash it just doesn't do it. Even with full logging on nothing even shows in eventviewer as a reason why it didn't happen. This is true with a student mandatory profile, teacher mandatory profile or a full admin account. If you try to create a report with the wizard it lets you make all the choices and then when you hit finish it says "the report could not be created" still no report in event viewer of any restriction implimentation permissions error or anything. So basicaly I have nothing to go on at all for my fault finding so. Has anyone seen this or anything like it before ?

  2. #2

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    Re: Access wont create reports

    There is also a GPO attched to the base workstation policy to restrict the universal file open dialogue and macros etc of office which applies to all 5 rooms and is being loaded and applied.

    Do you not think this may have something to do with it, have u tried enabling some of the restrictions you have made? work backwards, enable everything if you have to.

    Sometimes this has happened to us, were not sure why but we start a new databse and import the tables into it and then the reports work? who knows?

  3. #3

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    19

    Re: Access wont create reports

    The thing is 2 full rooms of machines are able to create reports just fine and they are subject to the same GPOs. The fact that an admin account cannot create a report either also lead me away from GPO as the cause.

    The only difference between the systems that can and those that can't is the windows install. They are a different RIS image but the same GPO deployed install of office. I'm just not sure what aspect of a windows install could cause this but I'll continue testing.

  4. #4
    StewartKnight's Avatar
    Join Date
    Jun 2005
    Posts
    1,587
    Thank Post
    2
    Thanked 27 Times in 21 Posts
    Rep Power
    30

    Re: Access wont create reports

    I found access didn't work unless the kids had full access to their folders. Not just the usual read and write malarkey!

  5. #5
    fooby's Avatar
    Join Date
    Dec 2005
    Posts
    351
    Thank Post
    0
    Thanked 5 Times in 4 Posts
    Rep Power
    19

    Re: Access wont create reports

    Is there a printer attached and configured with these computers?
    Access needs a printer (stupidly) to be able to decide it can make reports.

    This was the fix for a similar lack of ability in access.

    fooby

  6. #6

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    19

    Re: Access wont create reports

    Printers are assigned in the rooms by a script. I didn't have any complaints about printing today but first thing I check tomorrow will be that because I've had a similar problem with publisher and A3 pages. No error just wouldn't do it.

  7. #7

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    19

    Re: Access wont create reports

    Ok there may be a link here but its not a 1:1 link because theres a couple of machines that hte printing is working fine on that also have the report issue but it turns out there is a printing issue in the same room and the machine I've manually fixed it on can now create reports too so my new question is. How to I force 90 machines to reinstall a printer driver from the server without having to actually log on to each one? The printers run a script to add the printer s on each user logon but they seem to use a cached copy of the driver and get an error when trying to print. Is there a way to force them all to grab the driver from the server again as my forcing one to do just that seemed to do the trick.

  8. #8

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Access wont create reports

    You can either have the commands in a startup script or you can use psexec from an account/machine which has admin access on target machines.

    You can do alot of command line printer management using printui.dll
    Type
    Code:
    rundll32 printUI.dll,PrintUIEntry /?
    for a list of options

SHARE:
+ Post New Thread

Similar Threads

  1. Workstations on 7.91 wont upgrade to 7.95 - help
    By sidewinder in forum MIS Systems
    Replies: 6
    Last Post: 26th September 2007, 09:20 AM
  2. iBook G4 wont boot
    By sidewinder in forum Mac
    Replies: 11
    Last Post: 16th November 2006, 09:50 AM
  3. Why wont this PDA sync with exchange?
    By woody in forum Windows
    Replies: 16
    Last Post: 13th April 2006, 08:31 PM
  4. Replies: 3
    Last Post: 10th March 2006, 01:54 PM
  5. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 11:03 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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