473,573 Members | 2,918 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Unable to design/preview a report

I'm an Access noob and apologize if I'm asking a stupid question. The
problem is that I'm unable to design/preview reports on a database.
How do I go about fixing this?

Background -
A user has a database which I need to examine. This user is able
design/preview all reports on a certain database.
When I copy the database to my machine, I am unable to design/preview
reports. I am also unable to design/preview reports when I use my box
to connect to the user's database.

Thinking its security, I signed on to the user's box with my ID and
can design/preview reports. Next I connected to my box using the
user's box. I am able to design/preview the databases on my machine
by using their box.

Is there some setting on my PC that is preventing this?

Thank you for any possible answers,
MVSGuy (I'm still waaay outside my comfort zone)

Jul 5 '06 #1
12 2513
It sounds as if it could well be a matter of security.

Unless you copied the appropriate Workgroup file (aka .MDW) along with the
database, you'd have automatically used the default .MDW on your machine.
Did you log in to the user's machine with his/her or your own Access userid,
or not have to log in at all?

I'm no "expert" on Access security, but have used it enough to talk about
simple questions.

I never attempt to implement security on an Access database without a
careful review of the Access Security FAQ... it's not brief, and there's no
"filler" material in it... MVP Joan Wild, who _is_ something of an expert on
the matter, listed the following references:

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

and I'll add that there is some very good security information on Joan's
website, http://www.jmwild.com/index.htm.

Larry Linson
Microsoft Access MVP

Jul 5 '06 #2
I've signed on to both machines with both id's. Both id's work on the
users machine. The users id gets into report design/preview on my box,
but my id & box doesn't.

I'm not sure if this is making any sense.

More that somewhat puzzled,
MVSGuy

Jul 5 '06 #3
"mvsguy" wrote
I've signed on to both machines with both
id's. Both id's work on the users machine.
The users id gets into report design/preview
on my box, but my id & box doesn't.

I'm not sure if this is making any sense.
If by "making sense," you mean your description is understandable, yes, it
is. If you mean, "can you explain it?", then no I can't.

That _is_ a puzzler. I think you said you'd copied the database so that you
used the same database on both machines. But, just for grins, if there is an
..MDW file on your machine with the same name as the database, rename it, and
copy the .MDW file from the user's machine to yours and try again.

From what is happening, and not happening, it seems very likely to me to be
a security permissions problem. That user wouldn't happen to be the original
creator of the database, would he/she? If it is being opened with the
database owner's ID, that overrides security settings -- which is why
changing the DB owner is part of securing a DB.

Larry Linson
Microsoft Access MVP
Jul 5 '06 #4
Curiouser & more friggin Curiouser!!

Using the users ID on my machine, I exported the report to an blank DB.
I logged off the users ID & back on to mine.
I opened the DB & imported the report from the blank DB. As there was
already a report by that name, it suffixed a "1". But it DID import OK.
All as expected, right?

But I still can't design/preview this under my id. I get a brief
hourglass and then it returns to the regular mouse cursor.

I'm a noob and an MVS guy. This is WAAAY beyond my skill level. Is
there something stupidsimple I'm missing?

Regards,
kk

Jul 10 '06 #5

mvsguy a scris:
Curiouser & more friggin Curiouser!!

Using the users ID on my machine, I exported the report to an blank DB.
I logged off the users ID & back on to mine.
I opened the DB & imported the report from the blank DB. As there was
already a report by that name, it suffixed a "1". But it DID import OK.
All as expected, right?

But I still can't design/preview this under my id. I get a brief
hourglass and then it returns to the regular mouse cursor.

I'm a noob and an MVS guy. This is WAAAY beyond my skill level. Is
there something stupidsimple I'm missing?
>
Regards,
kk
Is there a printer installed on your box?

Sebastian

Jul 10 '06 #6
Is there a printer installed on your box?
Yes. Are you suggesting I hilight the problem report and attempt to
print? If so, I just tried this.
When I tell it to print, I don't even get the printer select window.
In effect, it's performing exactly like the design/preview selection.
Specifically, ignoring it.

Regards,
kk

Jul 10 '06 #7
"mvsguy" <kk*****@fuse.n etwrote in
news:11******** **************@ 35g2000cwc.goog legroups.com:
Curiouser & more friggin Curiouser!!

Using the users ID on my machine, I exported the report to an
blank DB.
I logged off the users ID & back on to mine.
I opened the DB & imported the report from the blank DB. As
there was already a report by that name, it suffixed a "1".
But it DID import OK.
All as expected, right?

But I still can't design/preview this under my id. I get a
brief hourglass and then it returns to the regular mouse
cursor.

I'm a noob and an MVS guy. This is WAAAY beyond my skill
level. Is there something stupidsimple I'm missing?

Regards,
kk
Let's do a test: On your machine, find the file system.mdw.
Temporarily rename it. Transfer the system.mdw from the user's
machine, try to open the database and report.

If it works, the user has modified the user-level security for
reports on his machine.

restore your original system.mdw and come back for repair
instructions.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 10 '06 #8
Transfer the system.mdw from the user's
machine, try to open the database and report.
When the problem was originally encountered, my machine had no *.MDW
files. I copied them from the users machine.
To follow your suggestion, I zipped up all the MDW's on my machine.
Then I copied SYSTEM.MDW & SYSTEM1.MDW into C:\WINDOWS\SYST EM32. Next
I did a shutdown & restarted.

Design/preview is still ignored when looking at a report.

Is there something wrong with my testing methodology?

Regards,
kk

Jul 10 '06 #9
"MVSGuy" <kk*****@fuse.n etwrote in
news:11******** **************@ 35g2000cwc.goog legroups.com:
>Transfer the system.mdw from the user's
machine, try to open the database and report.

When the problem was originally encountered, my machine had no
*.MDW files. I copied them from the users machine.
To follow your suggestion, I zipped up all the MDW's on my
machine. Then I copied SYSTEM.MDW & SYSTEM1.MDW into
C:\WINDOWS\SYST EM32. Next I did a shutdown & restarted.

Design/preview is still ignored when looking at a report.

Is there something wrong with my testing methodology?

Regards,
kk
No system.mdw? impossible, unless access didn't work. Maybe
that's a pointer to the problem. Find any other .mdw files on
your machine?

From the menu,
tools->security->workgroup administrator.
This should tell you what .mdw is used on each machine.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 10 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
14352
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to display the graph but it is not possible to send query parameters to an OLE graph on a report (or programatically change any properties of an OLE...
4
5858
by: Jeff | last post by:
I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart. This results in a flash of the report in design mode just before it is opened in preview mode. Is there any way to open it in design mode hidden? Jeff
4
2817
by: Gary | last post by:
Hello, I'm hoping someone can shed some light on why my report does not output the same results as shown in preview mode, which is to move the position of a check box based on a field value (see code below). The code does exactly what I want only in preview mode; it moves the check box only when the drug criteria is true. However, when I...
4
1704
by: vermutmb | last post by:
I must be missing something, but I have a report that when it is opened programmatically as a Preview, there is a limited toolbar which prevents the ability to edit the design, among other things. However, if the use presses the <ESCAPEkey, it automatically reverts to Design Mode. How do I prevent this?
8
2342
by: paii, Ron | last post by:
I have a report that is opened in preview mode, the users can view it then send it to a printer. I want to; in the same command display a dialog box with "Yes/No" to confirm the next step. How do I pause the code until the report is closed? If I display the message after the report preview, the box is opened over the report and the users...
6
12167
by: rewindspline | last post by:
hello, i have a simple MS Access 2003 database for producing reports from multiple tables. this morning i made a slight change to some text boxes in the report and now i can't open the report. the change i made was to copy some text boxes from one report to this report (for consistent appearance). there is no response when i double-click...
1
3072
by: mailjaneen | last post by:
Hello, can someone help me. I want to display some fields on a report in print preview (i.e. instructions), that I don't want to print to the printer or export to file. I can't seem to find any way of telling that the report is displaying in print preview, vs. being actually printed or emailed/ exported. So for example when previewing,...
5
4693
by: jamesnkk | last post by:
Hi Could someone assist - When user preview the Report, he or she can right-click to change the report. how can I disable the Report Design option to prevent them from changing ? After closing the preview report and return to the main form, I notice the main form size or position change, is there anyway I can maintain the original size of the...
4
4990
by: scubasteve | last post by:
I've developed a product pricing application for a client in AC2007. They enter all the data on the one main form, then click a button to open a printable report in Print Preview. My problem is, once in Print Preview, the Close Print Preview button on the ribbon doesn't work. It's there, it just does nothing when I click it. To close the...
0
7694
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8021
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7787
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5593
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5291
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3733
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2213
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1041
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.