add trusted location - all Users?
Wed, 12 Mar 2008 12:00:00 -0700
Is there any way to add a trusted location for ALL users on a PC?
We have a network DB that is used by all staff - PC's are shared by shift
workers...
It would be hard to catch them all - and time consuming to reset passowrds
to log in as each one.
We just upgraded to 2007 - and need to do this asap.
Any sug ...
|
Problem with report permissions
Wed, 12 Mar 2008 11:46:01 -0700
I am having a problem here. I have security setup ofor a database. The users
are surposed to be able to click on a button and open a for. I gave them
Open/Run and Read Design permissions but Access still won't open the report
and shows them not having permission to modify the report. They are just
supposed t ...
|
Security on for all dbs!
Wed, 12 Mar 2008 04:42:02 -0700
Hi,
I have activated the security and set up groups, etc on a db. But, now when
I open any other Access db, it also asks for the Admin password. Is it
supposed to happen?
Ciao ...
|
Adding username to table
Wed, 12 Mar 2008 04:11:02 -0700
Hi there,
I've now read the security FAQ and succesfully set up security with users,
passwords, etc on my db. My db is form-driven with menu's, etc... running off
linked SQL tables. However, I have the following two questions:
1. How do I add the username per record added? and
2. How do I get around the e ...
|
How to secure database in access 2007
Tue, 11 Mar 2008 13:43:02 -0700
Hi all,
I am using access 2007 and created a database. I changed my file to MDE and
disabled some options using the access option. Now the database runs directly
the switchboard and I added some bottuns in my switch board which linked to
the forms where the users can enter data.
some of the users finally ...
|
network users can't connect to backend tables
Tue, 11 Mar 2008 11:25:02 -0700
I have created and Access 2007 app. I split the db and put the backend on a
Windows 2000 Server. I have set permissions on the db_be.ACCDB file and the
directory that it is in to include full control by everyone and the user
account that we all use. There is no problem reading and writing to this
directory, ...
|
Multiple Users 2007
Tue, 11 Mar 2008 10:19:05 -0700
I have a database in Access 2003 with multi-level users and passwords. I see
that Access 2007 does not offer that feature any longer. What should a
person do if they have a database in Access 2007 and they only want read-only
users. I don't want my data to be corrupted inadvertantly. I would like
myself ...
|
|
|
Password as ******
Tue, 11 Mar 2008 08:52:43 -0700
Access 2003
I use this code when opening a form.
Private Sub cndAdminArea_Click()
Dim password As String
Dim Answer As String
password = "admin"
Answer = InputBox("Enter Admin Password: ", "Admin Confirmation",
"Enter Password")
If Answer = password Then
DoCmd.OpenForm "frmUp ...
|
Why is Access broken?
Mon, 10 Mar 2008 22:08:00 -0700
I have Access 2007 installed and recently tried to open an mdb that I have
used before. Access asked me to "Logon". Now, I do not use security on any of
my databases as they all are local to my computer, so I never set up an Admin
password or set user level security on the files.
I tried to create a new db ...
|
Running ms access modules as admin but logged into access as a regular user..
Sat, 08 Mar 2008 19:59:44 GMT
I am currently working on an ms access application for a large insurance
company which generates reports for the user after the user inputs/select
some data....
Unfortunately the application has already been built - and till now we used
to run the application/reports by logging in as admin.. however, we now wa ...
|