|
Forgotten Password
I am trying to login into a database and have forgetton the password, any
help in the best way to get around this? I know, and it won't happen again!...
|
3 |
21.07.2006 12:22:01 |
|
|
Individual Record Permissions
I am creating a database for students' profiles. I have one table, with each
record being a different student and information. I would like to set up
security so that the student can only modify their record, and only view
everyone elses.
Any ideas how this can be achieved? My current theory is to check the
username they are logged in as, and then lock/unlock the textboxes whether ...
|
2 |
21.07.2006 01:17:47 |
|
|
New Security User
I have a new database that I am trying to figure out the best way to secure.
This database will collect input from an ASP web form that feeds into one
specific table in the database. The problem is that I do not want any body
besides the Admins group to be able to see the data within this table. Is
there a way to allow a wide variety of people to update a table without
having read access to...
|
2 |
21.07.2006 01:09:32 |
|
|
If faq_IsUserInGroup Syntax for three groups.
I writing my code that will enable/disable controls based on the user groups.
What I am finding is that when I set my code for one particular groups it
affects the other groups. So my question is, will I have to use the If
faq_IsUserInGroup statement for all of my groups?
For example,
I have 7 controls on my form.
I have the Admin, Manufacturing, and Regulatory group.
I have se...
|
6 |
20.07.2006 21:01:20 |
|
|
Security Alert in Access 2007
I am testing the Office 2007 Beta and I am pleased with a lot of the new
features. However one feature is really bugging me. It is the Security Alert
in Access.
Why does it keep asking me if I want to enable contents and then it asks
again.
My computer created the databases that I am testing so why can't Access
assume that I want to 'enable content'. Why is there not a button to 'alwa...
|
14 |
20.07.2006 19:10:42 |
|
|
Security Features on Access Database
Hi,
This is going to be my first time adding security features for my
database.
I want to give access to my database to my boss and his boss. But I
also want other people to look up stuff if they need to. Like look at
reports and Queries. But I don't want them to change nothing.
How can I do that?
Thanks in advance.
JM
...
|
2 |
20.07.2006 15:47:33 |
|
|
Self-Signed Certificate how to export?
Hello,
after many nightmare about getting rid of Access security warnings popping
up on computers of few members of our staff (all of them will use the runtime
version of Access) that use an application developed with Access 2003 and
deployed with the Package Wizard provided with the Acees 2003 Developer
Extension, I come up with the need to sign my VBA project with a self-signed
certif...
|
2 |
19.07.2006 23:37:01 |
|
|
Programatically load a form based on user login.
Scenario.
I initially created a switchboard using Switchboard, but based on previous
advise, I created two forms instead ; Manufacturing and Regulatory. These
forms are based on two groups that were created in Access security tool.
(These forms contain controls to other objects -,,,Forms and Reports"
What I would like is that; Once a user in the Manufacturing group logs into
the...
|
9 |
19.07.2006 22:11:48 |
|
|
Syntax
What is the proper Syntax for using the
IsUserInGroup Function in a Form's Open Event Here is my current Syntax but
I am getting the following
error message: Expected End Sub
Private Sub Form_Load()
Function faq_IsUserInGroup(strGroup As String, strUser As String) As Integer
' Returns True if user is in group, False otherwise
' This only works if you're a member of the Admins gr...
|
2 |
19.07.2006 19:58:57 |
|
|
security applied to all my DBs
I setup security groups and users for a particular DB, now when I open
any DB it requires that I login. I did not intend for that, and it will
be a problem for other users with limited privileges. How can I use
security for just a single DB rather than all DBs?
Shane
...
|
5 |
19.07.2006 18:59:02 |
|
|
I have set my Start up to not allow some menus and toolbars
on saving a access program i went into startup and got rid of all access to
menu bars qnd toolbaes , but now i can not get them to come back again in
this program
can you help please !...
|
3 |
18.07.2006 23:43:01 |
|
|
Diff Workgroups, Same DB, diff Security
After a day of struggling with it, I finally created a new workgroup with
myself as the administrator of a user-level secured DB, with others having
limited permissions.
I tested the security by logging onto the DB as one of the limited
permission users. All was as expected until...I changed workgroups and
joined the default system workgroup (the one that comes with Access
installa...
|
5 |
18.07.2006 20:29:02 |
|
|
Switchboard Security
Is there a way to restrict users from clicking on a command button on the
main switchboard.
Scenario:
I have created two groups, manufacturing and regulatory.
On my switchboard I have approximately 10 command buttons. Out of these
command buttons, I would like for the Manufacturing Group to only be able to
click on the Close command button, Reports Menu Command Button, and Add ...
|
3 |
18.07.2006 20:25:04 |
|
|
MS Access 2003 - Owner
I'm used to Access 97 security, so with 2003 I created a work group file and
a blank database, logged on with MyID and created a new database, which
opened immediately. MyID was the database owner until I logged out. When I
logged on again the default 'Admin' user was now the owner.
Is there any way for MyID to retain or obtain database ownership?...
|
2 |
18.07.2006 20:17:37 |
|
|
can't run report from crystal reports
I'm trying to run a crystal report from an access database.
When trying to select any table from this database as the data source I get
the error:
Query Engine Error: 'DAO Error Code: 0xC26 Source: DAO.Fields
Description: Could not read definitions; no read definitions permission for
table or query '(1)School Info'.'
I suspect that it has something to do with the security of the d...
|
6 |
18.07.2006 19:29:08 |
|
|
search form not working properly
I have a search form that has one text box that is input procedure into a
query.
using query expression :
Like "* " & [Forms]![test]![keywordsearch] & "*"
That works.
I have the query run on searchform opening and a requery button to re run
the search with the user defined values (using a requery action macro)
I tried to add another two boxes and have it so the results returned depe...
|
2 |
18.07.2006 09:40:23 |
|
|
Password on BackEnd
Hi,
I have set a password on my backend DB.
In my FrontEnd DB I call a table with the following code :
Dim dbs As Database, rst As Recordset
Set dbs = CurrentDb()
Set rst = Openseek("Table")
With rst
rst.Index = "ID"
rst.Seek "=", Forms!XXXX!ID
this code calls the following function to connect the table.
Public Function openseek(table) As Recordset
...
|
1 |
18.07.2006 08:45:01 |
|
|
Password to open section of Ctrl-Tab
I have created a Ctrl Tab to move from one section of a form to another. Is
there any way I can write an "Event Procedure" - On Click - that requires a
Password before the user can enter this section of the form?
Thanks for any help
Roger...
|
1 |
18.07.2006 02:11:02 |
|
|
Is there a way to change an Access .ldb file to a .mdb file?
...
|
2 |
17.07.2006 22:04:10 |
|
|
Access 2000 quits with digitally signed code
I have an app developed under Access 2000 which runs fine. Some PCs have
been upgraded to Access 2003. Rather than set security to 'Low' to avoid
nagware, I digitally signed the VBA. This works fine for Access 2003. But
for Access 2000, the database will open OK but quits when I try to run any of
the VBA.
If I try to view the project under Access 2000, I get 'project is
unviewable',...
|
1 |
17.07.2006 19:38:03 |
|
|
Restricted permissions
I cannot open my Access database as each time I logon I get the error "You do
not have the necessary permissions to use...Please have your system admin..".
I created the database, and have a workgroup file with user level security.
I can open the database fine from any other computer on the network but not
my computer. I have tried reinstalling office, recreating the workgroup file
and ...
|
2 |
17.07.2006 19:37:19 |
|
|
Access 2000 Security - Workgroup, Owner, User Permissions etc., H
I am attempting to grab some information from an Access 2000 database after
the system from which it originated crashed.
The information I have for this database is the password for entry to the
database and a USER and its ID.
Now, my question is, what do I need to do to setup an alternate machine to
access this database. I've tried adding the USER to the system with
Administrative ...
|
3 |
17.07.2006 17:18:01 |
|
|
How do I setup a Password in MS Access.
Can you please help me that how i setup a password in MS Access Database for
different user to different password?
...
|
2 |
17.07.2006 11:45:07 |
|
|
deleting microsoft access user passwords
I need to delete user passwords as the administrator on a access program, and
have followed the "Help" instructions to no avail. ...
|
4 |
17.07.2006 00:16:24 |
|
|
log on screen in Access?
For a reason unknown to me, Access now requires me to log in before doing
anything. I did not set up any permissions and I am the only one using the
program (on a personal computer). I cannot do anything at all... cannot
create a new file, cannot open a template... nothing. Everything requires a
log in which I do not have. I have even uninstalled and clean installed the
program to try t...
|
6 |
16.07.2006 16:55:34 |