|
Who's in charge here?
I'm very new to Access security, so please bear with me. We are using Access
97, and there is a permission problem. All of our other databases are
running smoothly, but one database disallows access to any of the tables. I
check, and it says I am logged in as Admin. It also shows Admin being a
member of the Admins group. Somehow, the Admins group lost Administer
rights, and I can't ...
|
4 |
17.08.2006 20:48:20 |
|
|
Masking Social Security numbers
I need to be able to run a query in Access 2003 that takes the
information from a field "Social Security Number" and masks all but
the last four digits. Is this possible?
...
|
6 |
17.08.2006 17:37:40 |
|
|
The Exclusive open mode is not working as it did when first applie
I went to Tools, Options, Advanced and set the default open mode to
exclusive, and default record locking to All Records. When I did this
initially, only one user at a time could open the database, any additional
person who tried to open the database got a message telling them they could
not get in because someone else was using it. NOW, however, it lets
additional people in, and lets ...
|
1 |
17.08.2006 15:51:02 |
|
|
Wizard Issues
I secured my database using the wizard and am supposed to have multiple
users. Everything worked great on my computer. When anyone else tried to open
the file, it said they didn't have the correct permissions. I used the user
names to match our Windows logins. What did I do wrong? ...
|
4 |
17.08.2006 15:19:56 |
|
|
Why are all access database I open asking for log on?
I recently added security to an existing 97 Access database. Now when I log
on to all of my other databases (both 97 and 2000) they are asking me for a
username and password. These databases previously did not require usernames
and passwords. Any idea why this happening and how to fix it?...
|
9 |
17.08.2006 12:24:43 |
|
|
DB Problem -XP Client / 2003 Server
Problems running access databases, residing on 2003 Server, from XP Client.
1) If a database is already open by another user the application will not
run. Get no error messages either. How can we access already open databases?
2) If a database can be opened an 'open file security warning' window
appears from which we can access the database. How can we disable this window?
We only hav...
|
1 |
17.08.2006 11:28:01 |
|
|
PASSWORD PROBLEM in .MDW FILE
we are not able to access our mdw file. it says: Not a valid account or
password. I guess the password was changed somehow. How do we hack into
our mdw file and find out our password?
please please help
thanks
...
|
5 |
17.08.2006 10:56:02 |
|
|
Load Form Based on Current User's Group
I have a Timesheet application for which I will be using Security for the
first time. Most users will have read/edit permissions for a single form, by
which they enter their time spent on various projects. I would like to load
an Administration Menu form on startup for those in the Admins group, and the
Timesheet form for the Users.
Prior to securing the database, I've set the Adminst...
|
6 |
16.08.2006 19:53:01 |
|
|
Locking a database
I have an Access2000 application with 3 linked databases (tables only). I am
trying to lock the application down so users who have full MS Access
installed cannot get to the data by going into the database window and
opening any table(i.e. they should only be able to view data via forms), this
is because the database contains settings for many other users and should be
private.
Each ...
|
7 |
16.08.2006 19:30:36 |
|
|
Help with an IF statement for the groups
Hello
I have 2 groups: Admins, EnterData
I want to display some objects in my forms when the EnterData group
users are logon and display all the objects when the Admins are logon
on.
My question:
Where do I put the code, is it under: Form Load, Form Open, or where?
What is the actual code that I need to write in order to implement what
I want
Thanks
...
|
8 |
16.08.2006 19:30:12 |
|
|
HOW DO i SET UP MAILING LABELS FOR MANY PEOPLE
...
|
1 |
16.08.2006 15:28:02 |
|
|
Need help with security
Hello all
I need to secure my database. This is the first time I am doing this,
so I have no clues oh how to do this. Basically, I have a Expense
Report Interface, I want only the manager to be able to look at all
employees and access to all the reports. On the other hand the
employees only access to THEIR OWN employee ID and no access to some of
the reports and of course no access to othe...
|
15 |
15.08.2006 20:49:45 |
|
|
Need help securing an application with detail records
Hello all
I have an Expense Report Interface for the employees use in the
company. I need to setup the permissions so the user who logon can ONLY
see his records (his employee information and all the reports that he
had submitted so far), also this user should has the ability to fill
out 2 of 3 forms and see 1 of 3 reports. On the other hand I need to
create another group that can do whate...
|
3 |
15.08.2006 20:22:54 |
|
|
shift override in split database
Hi
I have a split database, both parts (FE and BE) have been copied to provide
a development database. Both use the same workgroup file.
When I further develop the database and try to distribute it for live use,
all of the security groups and access rights change, so I have to spend
several hours reinstating them every time. How can I stop this.
Also, I went to great lengths to secu...
|
6 |
14.08.2006 15:00:19 |
|
|
Logon to Access
Some time ago I was experimenting with Access security. As a result, every
time I open any Access database, I am asked for a name and password in the
"Logon" box. None of my databases have passwords and this box comes up for
every database I open, even new ones. I have tried every possible password I
would ever have come up with to log on as "Admin" but nothing works. I've
tried crac...
|
3 |
14.08.2006 01:58:01 |
|
|
Network security
I am using Access 97, I have completed building the program, there will be
other users who will be using the program. Is there any way to set it up so
that they can view the records, and add new ones, but not be able to alter
anything already entered, or change the forms.
I have tried to set up an admin security, but half way through I was locked
out and had to back up the computer to ga...
|
3 |
13.08.2006 19:24:23 |
|
|
Open a secured database and run a code procedure
I would like to open a workgroup secured database and run a code procedure in
it. I'm having a lot of trouble with the Shell command. In reviewing
previous posts, it looks like OpenCurrentDatabase can't be used in this case.
I don't actually want the user to know that the secured database has been
open; i.e. no visible window, if possible.
Thanks.
--
Message posted via AccessMonste...
|
1 |
12.08.2006 23:46:00 |
|
|
The Art of Defeating a PayPal Scammer - Part II
While scam baiting might seem fun, it has little impact on the
scammers. Most of the fake sites simply move on to another location.
Moving (frequently) is part of their standard method of operation to
confuse investigative efforts.
What will have a more (lasting) impact is getting the information to
places that have the resources to put a few of them in "jail." There
are a lot of places yo...
|
1 |
11.08.2006 16:57:15 |
|
|
Splitting database with password
I wish to split my Access database 2003 which has 25 tables. I used the
splitting wizard but the backend database then has no password. When I add a
'be' password the 'fe' cannot access the 'be' because of the new password. I
can't find an easy way of putting the password into all the linked tables so
that the 'fe' can access them. I could delete the links and then relink all
the tables ...
|
2 |
11.08.2006 16:41:45 |
|
|
ODBC - insert on a linked table failed. Read Only issue? Access 2.
We are having trouble updating an Oracle table through MS Access. We
recently switched from 2000 to 2003. It is a shared database, and sometimes
it works, but one person continually gets the error:
ODBC - insert on a linked table 'tablename' failed...
[Oracle][ODBC][Ora]ORA-01456:may not perform insert/delete/update operation
inside a READ ONLY transaction (#1456)
We have unchecked the...
|
1 |
11.08.2006 16:30:02 |
|
|
Database Read-only after installing
I have developed an application using access as front end and back end. I am
not using workgroup security (ie all users will be admin) the program part is
distributed as mde and the back end as mdb, the package also includes Access
2003 runtime and a dll that I have written. The developer's extensions are
used to package the app (using the package wizard). I install the app on a
stand-al...
|
1 |
11.08.2006 05:09:01 |
|
|
Secure Access for menu only use with menu items active by user
I have used the wizard to secure my database for use by higher level users,
but I wish to create limited user groups that
a) cannot “unhide" their underlying tables
b) can only use the database via the menu system created using the 2003 menu
system
c) can only perform selected functions (form use, report view/print) from
that menu system as defined in the security profile for that logg...
|
1 |
10.08.2006 19:00:02 |
|
|
you do not have the necessary permissions
I need help.
I have a front-end DB that I can no longer open but I can open the backend
DB.
My PC was recently re-imaged and I don't think the current system.mdw is
correct. I inherited this DB and I'm told it did not have a password but now
I'm receiving the "you do not have the necessary permissions..." error
message. How to I fix? ...
|
1 |
10.08.2006 18:46:01 |
|
|
database security
I tried to set sercurity for a database. Now when I am trying to open a new
or existing database, it is prompting for user name and password. I tried
using all the users name that I created but nothing is working. Tried to
uninstall and reinstall office but with no success....
|
3 |
10.08.2006 15:26:46 |
|
|
please help
hi all help needed.. Can I customize the access icon of my database (am very
very new to access)
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200608/1
...
|
3 |
10.08.2006 14:51:38 |