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)
12  2531 
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
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
"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
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
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
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
"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
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
"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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 Graph).
However with a Form you do have the ability to change the RowSource of
|
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
|
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 print the
report the check box position remains unchanged.
I tried putting the same code to both the...
|
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?
|
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 cannot work with the report.
| | |
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 on the report inside access. the report will not respond to desgn view, print preview or export and...
|
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, I'd do Me!.Visible =
True.
|
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 main form?
|
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 report you have to press Ctrl+F4.
This is bad, but worse is I can't even put a message on the...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
