|
User Accounts in Access 2007
Dear All,
I have a database that I am placing on a server via the package wizard &
runtime (i'm the only one with Access).
Before I do this, I need to set up security so that there are 2 types of
user able to use the database, 1 type that is read only & 1 type to edit &
input information.
Please could someone help me with how I go about this.
Thanks
Samuel...
|
4 |
12/11/2008 4:47:01 PM |
|
|
How to recover forms
Res. All,
I had developed an application in Microsoft Access secured with a
workgroup file(*.mdw). I had put securities in such a way that the users
will not have the mdw file created by me and then they will open the
forms,reports etc. They can only open the forms but they can not make
changes or view the design of the form as they are not given permissions for
that.
Now the probl...
|
2 |
12/11/2008 4:40:29 PM |
|
|
To prevent copying the objects of the access database
I have created one bibliographic database using Access 2003 in support of my
Ph D thesis. I have to send this for evluation during submission of the
thesis. So I need to provide ultimate security to the database. For this
purpose I want to prevent any mode of copying the objects of the database.
Even I dont want to show the database window as I designed start up form.
What should I do.
...
|
5 |
12/11/2008 1:35:50 AM |
|
|
Large Number of Event ID 537
I'm getting the following in one of my customer's SBS 2003 server:
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 537
Date: 12/09/2008
Time: 5:35:18 AM
User: NT AUTHORITY\SYSTEM
Computer: SERVER1
Description:
Logon Failure:
Reason: An error occurred during logon
User Name:
Domain:
Logon Type: 3
Logon Process: Èùö
Authentic...
|
3 |
12/10/2008 1:05:51 PM |
|
|
Permission on access 2007
I have upgraded access recently and ever since, every time I'm trying to
create new quires and a window opens up saying I do not have permission. I
tried logging in as an administrator but no luck, please advice....
|
2 |
12/10/2008 5:32:23 AM |
|
|
Hide backend folder
I have seen suggestions for hiding the share in which the backend files are
located (split database, Access 2003, User-level security). The suggestion
I have seen Joan Wild post is:
\\servername\share$ rather than
\\servername\share will hide it
However, I can't quite sort out what that means. Do I need to get the
newtwork administrator to create a share on the server with a $ appen...
|
5 |
12/9/2008 9:05:55 PM |
|
|
Protect tables
Hi,
I'd like to protect all the tables in my database so that no one can open
and look at the tables. What I did is the following
1. in my form, I set it "modal".
2. I set all of my tables hidden.
3. I convert the database to .mde.
Is this enough to protect the tables?
Thanks,
Boon
...
|
2 |
12/9/2008 8:29:46 AM |
|
|
multi-select fields in design view
All of a sudden I am unable to drag my mouse across several fields and select
them all.
What setting did I change to do this?...
|
3 |
12/9/2008 8:12:01 AM |
|
|
Lost Admin account on access mdw file
We just merged with a company and they have some access databases. No one
remembers the admin passwords for the workgroup security. Do I just cave in
and buy one of the security stripping utilities or is there another way
around this.
...
|
2 |
12/6/2008 4:13:21 AM |
|
|
User Level Security problem in Access 2003
I created an Access database with linked tables to a SQL database. I then
used the Security wizard putting myself in the admin group and one user in
the read-only group. I did something wrong as this affected all of my Access
databases.
To remove the security I followed instructions in
http://office.microsoft.com/en-us/ork2000/HA011381181033.aspx. I also
removed the read-only user. I w...
|
3 |
12/6/2008 12:21:46 AM |
|
|
HELP!
There was an existing database in 2003 that I imported to a new one and made
some improvements too. I purposely made a new one to overwrite a very
troublesome security .mdw file. Some network person has been working with
adding new users and I know has run the security wizard. The other day all
users had no permissions to get in the database. Then I went over there and
reinstalled a back...
|
2 |
12/5/2008 6:04:22 PM |
|
|
Options greyed out
I want to add a new user to an Access 2003 workgroup. I can add the username
OK but can't set any permissions. The Options "user and group permissions"
and "user-level security wizard" are greyed out on the menu. I am logged in
as an admin user. What can I do to get these menu items to re-appear ?...
|
3 |
12/5/2008 3:46:10 PM |
|
|
Joining MDW security group in Access 2007
I have 25 users using Access 2000, 2002, 2003.. they all use a shared MDW
file with all of the users and security
We have several new users with Access 2007.
How do I join the 2007 access users to the MDW file that exists so they have
the same user access.
I don't mind copying the MDW to thye new users computers to join them there
if necessary.
Thanks
Tom
...
|
2 |
12/5/2008 2:39:03 AM |
|
|
Security Warning
I am getting a Security warning such as below everytime I go into Access
2007. Should this really be occurring or is there something that can be
changed to avoid this?
"Microsoft Office Access Security Notice
A potential security concern has been identified.
Warning:It is not possible to determine that this content came from a
trustworthy source.You should leave this content disabl...
|
2 |
12/5/2008 2:22:34 AM |
|
|
User log in
Access 2007
I want to add a user login to my Access 2007 file.
Users will have to present a username and password and depending on their
what they enter will have certain restrictions on what they can access.
I understand that this was a built in functionality in Access 2003 that has
been removed in Access 2007.
I have also heard that the easiest way to do this is convert my DB to 2...
|
8 |
12/3/2008 11:27:02 PM |
|
|
Check if VBA Code is Disabled
Running Access 2007 on Vista.
I have a database that I'm trying to give some bare bones security to that I
need some help with. I have a table of usernames and passwords and a form for
the users to enter their username and password into. I have the form opened
when the database is opened via the Autoexec macro. The issue is, if the
database gets moved or copied to somewhere that isn't a...
|
2 |
11/30/2008 3:08:19 AM |
|
|
Can't Install Add-In
When I try to install Ezy Access Dashboard Builder Add-In for Access
2002/2003/2007
v1.0 3:40 PM 29/08/2008 I get the following:
"You do not have sufficient security permission to install this Add-In."
I've modified the registry as per the following article suggested be the
readme:
http://allenbrowne.com/bug-17.html
Users now have Allow Full Control and the Read also became
checked after...
|
2 |
11/28/2008 10:44:44 PM |
|
|
Outlook 2007 password prompt
Just installed Outlook '07 last week. It keeps prompting me for my password.
How do I stop this from happening?...
|
2 |
11/27/2008 6:45:00 PM |
|
|
Linked database access
I have a database that is being used my multiple users and is using Access
security. For a particular user I would like to provide them with a
different database that is table linked to the primary database. This ad hoc
database will allow the user to create their own queries and reports.
However, I do not want to all the user to be able to update the primary
database through his link...
|
2 |
11/27/2008 3:32:18 PM |
|
|
You do not have the necessry permissions to use the 'DatabaseLogon
I am getting this popup message when users login using a read only access
security group that I have assigned for them. How do I change this popup to
something friendlier? I am using the correct System.mdw file.
...
|
1 |
11/26/2008 10:22:01 PM |
|
|
how do i reset a password (can't access any DB)?
I followed the ecurity wizard to protect an access DB, was not asked for any
password and now when i open a DB (whichever) i am prompted for a password.
How can i reset this completely (without losing my DB!)
thanks...
|
2 |
11/26/2008 3:42:24 PM |
|
|
access the HTML page from website and security question
Hi,
There is link on our company website linking the defult.html file which is
the homepage file generated by the access database. The company website is
hosted by another company. While ago, the hosting company modified our
website and link does not link to the default.html file anymore (there is a
login box asking for userID and password, but after click on the submit
button, nothin...
|
1 |
11/25/2008 9:23:01 PM |
|
|
First time setting up security
My question is 2-in-1. I have a time tracking database for 30+ employees. In
it their is a time card report where (currently, anyway) you select a person
from a drop-down list and it generates that person's "time card". This
current system is not restrictive enough from an HR perspective. I need to
set up security so that each of the 30+ people can log on with their own
password and s...
|
2 |
11/25/2008 1:47:47 PM |
|
|
Why does it tell me that my passport authentication failed?
I am trying to sign up for the Equifax credit profile for my business, but i
have signed up five times, and it says the same thing everytime--password
authentication failed. EMPTY...
|
2 |
11/24/2008 10:00:51 PM |
|
|
Problem with user-level-secuity
I created the following shortcut that users use to access the DB using their
assigned login and password:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Unified Doers
Management Group\UD_Management Group.mdb" /WRKGRP "C:\Unified Doers
Management Group\Security.mdw"
Works fine.
However, the DB will open if they double-click <UD_Management Group.mdj>.
Which def...
|
2 |
11/24/2008 6:13:23 PM |