Locked out of Reports (Can't find my last post!!)

[Frankie The Flyer]

I've created a data base that relys on reports to display the data. On one
out of 4 computers that use the information from a server I can't open or
edit any of the reports. I've tried both through the switchboard and directly
from the db window without success, yet they work on the other computers!!!

Any ideas please??

 

[Arvin Meyer [MVP]]

Hopefully, you have separate front-ends connected to data on a server. If
that's the case, you can delete or rename your front-end and copy one from a
working computer. If that's not the case, you will need to describe your
setup and any error messages you are getting.

 

[Frankie The Flyer]

Thanks for the response. The front ends are actually seperate from the tables
but the computers all have shortcuts to the same front end (on the server).
There are no error messages and initially clicking on the button on the
switchboard causes the "eggtimer" to appear for about 4 seconds, then
nothing..............!
On the other computers the eggtimer appears followed by the dialogue boxes
asking for the start date etc for the query search.

 

[Arvin Meyer [MVP]]

Make a copy of the front-end and put it on each workstation. Sharing a
front-end can cause corruption. Back-ends on the server are designed to
properly lock records and be shared.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Dirk Goldgar]

I've created a data base that relys on reports to display the data. On one
out of 4 computers that use the information from a server I can't open or
edit any of the reports. I've tried both through the switchboard and
directly
from the db window without success, yet they work on the other
computers!!!

Any ideas please??

Possibly that computer doesn't have a default printer defined.

 

[Frankie The Flyer]

Thanks again for the feedback. I've tried that and there is a default
printer. I even changed the default and re-booted without any change to the
issue. Oh well!

 

[Frankie The Flyer]

Ok.... tried that with no change. It's really quite strange because the
switchboard button "clicks" but then nothing happens. On the switch I have a
button for producing the report and one for e-mailing the report. If you
click on the E-Mail report the macro stops as it can't open the report either
- but only on the one computer!

 

[Arvin Meyer [MVP]]

If a working copy from one computer, will not work on another, there are
only 2 reasons I can think of.

1. A default printer not defined, or that printer isn't available to the
second computer.
2. You have a corrupt installation, and need to uninstall, reboot, and
reinstall.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com