Print preview of form is blank & security questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to print a form I've developed, but print preview is blank. What
is wrong? Help wasn't any help.

My next question is about security. I set security on the database itself,
yet when another user who is "read only" had a form open today, I couldn't
open the database, & I'm the admin.

Should I remove all the security & rely only on the folder security set up
by IT?

Thank you for your help.
 
In answer to your first question, you should not print a form, you print
reports. Build a report.

For your second question, HOW did you set security? Setting up Microsoft
Access User-Level Security is a multi-step complex process. What steps did
you take?
 
I'm trying to print a form I've developed, but print preview is blank.
What
is wrong? Help wasn't any help.
Click to expand...

Why are you trying to print a form? Forms are designed for data entry. You
should create a report for your printing needs.
My next question is about security. I set security on the database
itself,
yet when another user who is "read only" had a form open today, I couldn't
open the database, & I'm the admin.

Should I remove all the security & rely only on the folder security set up
by IT?
Click to expand...

It may be that the folder security is part of your problem, but it's hard to
say without knowing your setup. To completely secure an Access database you
need to depend on, at least, 3 things.

1. Access User Level Security
2. Network folder and file security
3. Additional code in the application itself.

To set up User Level Security you need to follow the correct steps as
outlined in the Security FAQ. You can find a link to it on the Security page
of my website. I also have a page there that outlines it in a somewhat
simpler format, but you should still rely on the FAQ. You can also find a
good outline for it at http://www.jmwild.com/Accesssecurity.htm

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
I wanted to print a copy of the form, so I may use it as I design the form
for notes & other users would like to print for mtgs, etc.

I didn't use the wizard when setting up the security, I only did the user
groups & permissions, checking read only, etc.
 
I'm printing the form to utilize for reference in designing the form. I was
able to print yesterday & wasn't able to today.

Security was set up for the folder by IT, & I set the security on the
database, but didn't use the wizard.

I'll check out your web site. Thanks for your help.
 
Mary said:
I wanted to print a copy of the form, so I may use it as I design the
form for notes & other users would like to print for mtgs, etc.

I didn't use the wizard when setting up the security, I only did the
user groups & permissions, checking read only, etc.
Click to expand...

More than likely what you have done so far regarding security has been a
complete waste of time. Setting up Access User Level Security is one of the
more difficult concepts in Access and getting it right by "tinkering around"
is virtually impossible. Either obtain the explicit FAQ and step by step
instructions available on the web or forget about it.
 
I'm printing the form to utilize for reference in designing the form. I
was
able to print yesterday & wasn't able to today.
Click to expand...

Then I have no more complaint about you doing that. Is there any data
showing on the form when you open it?
Security was set up for the folder by IT, & I set the security on the
database, but didn't use the wizard.
Click to expand...

Make absolutely certain that all users (even the "read-only") users have
full permissions to the folder.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Again, you don't print forms. Build a report and add a print button to
your form. When clicked, have it print the REPORT for the current record.

As far as security, you left out about 90% of the steps involved in securing
your database. Anyone can take your database to another computer and open
it with no password entry and will have full access to it. All you did was
added a user and password to the default workgroup file on your PC. You did
nothing to secure the database fiel. Read the links provided by Lynn.
 
Back
Top