Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / May 2008

Tip: Looking for answers? Try searching our database.

The ol' "Reports Won't Open in Preview" problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roger Denison - 13 May 2008 17:01 GMT
I've several of the posts pertaining to this and have tried the suggestions
posted but to none avail.

I have a database from Access 2000 that uses linked tables to a SQLServer
2000 machine.  The Access file sits in a shared folder on the same machine as
the SQL.  Most of the clients are able to use the Access application to
generate report previews.  However, one group of clients can open the forms,
select the parameters of the queries and try to generate the report but no
report preview shows up.  Just an hour glass for a second and then nothing.  
The Access app stays open and there is no problem with clicking the "Generate
Report" button a second time, but the issue remains: only a momentary
hourglass and then nothing.

I have verified that they are using Access2003 sp3, same as all the other
clients.  I've even gone so far as to connect to their printer and set it as
my default and yet I can still generate the report preview.  They can't.  
Anything else that could be causing this?  Again, this is a single Access
file that is shared by many.  No one else has problems with sharing
violations or messages of that sort.
John Spencer - 13 May 2008 17:53 GMT
Did you try giving them a copy of the Access file on their local computer?

How are you linked to the SQL server?  Could it be a path issue?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

> I've several of the posts pertaining to this and have tried the suggestions
> posted but to none avail.
[quoted text clipped - 15 lines]
> file that is shared by many.  No one else has problems with sharing
> violations or messages of that sort.
Roger Denison - 13 May 2008 18:57 GMT
That was going to be my next step.  But why would this affect only one
location and not the others?  Yes, I know there must be something different,
but what?

The Access link uses a File DSN with a SQL Server driver.  

> Did you try giving them a copy of the Access file on their local computer?
>
[quoted text clipped - 24 lines]
> > file that is shared by many.  No one else has problems with sharing
> > violations or messages of that sort.
Duane Hookom - 13 May 2008 20:54 GMT
I think this is still a printer/permission/driver issue. I would have the
users set a different default printer in Windows Control Panel.

You should trouble-shoot this be attempting to create any report even with
no record source to see if they can design, preview, or run the report.
Signature

Duane Hookom
Microsoft Access MVP

> That was going to be my next step.  But why would this affect only one
> location and not the others?  Yes, I know there must be something different,
[quoted text clipped - 30 lines]
> > > file that is shared by many.  No one else has problems with sharing
> > > violations or messages of that sort.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.