|
Toolbars/Startup for User Groups
I have a database set up with Full Data Users and then Admins. I would like
to be able to hide a toolbar or buttons on a toolbar for users in the Full
Data group, but then show all for Admins. Then I would like to have the
Database window appear upon startup for Admins (along with the switchboard)
and have only the switchboard appear for Full Data Users. Is there a way to
do this without codi...
|
3 |
11.05.2006 17:49:45 |
|
|
Help with security - Please
I am trying (unsuccessfully) to add a database to an existing workgroup file.
I am having continuing problems because I have never set up security on a
database. The workgroup I'm am trying to add the database to was set up by a
previous person and I am familiar with setting permissions, adding new users,
etc. but I cannot figure out what I am doing wrong. I have read several
threads ...
|
4 |
15.05.2006 14:34:01 |
|
|
users permission
i have new data dase there are 8 users i just want them to enter data in form
and take away the other permissions...
|
2 |
16.05.2006 13:57:01 |
|
|
foult of the firewall?
I cannot install anything..
http://s3.bitefight.pl/c.php?uid=45955
it's the screenshot
...
|
2 |
16.05.2006 12:27:26 |
|
|
Unauthorized user
Recently, I must allow Access to open an application I've been using for the
past 5 years. It asks if I want to block unsecured objects. Even when I
download Service Pack 8 for MS Jet 4.0, it still doesn't work right.
Even more recently, it simply says I don't have the user rights to open the
application and I should ask the administrator (me) to grant me the
permission!
Could this be du...
|
1 |
16.05.2006 10:02:01 |
|
|
Computer crash caused lost security
A colleague was working with Microsoft Access when his computer crashed. The
database he was working with lost security and administration rights. That
is, the database does not require user authenication(login was required
before his comptuer crashed) as well as the administrator is displayed as
'unknown'.
Any suggestions?...
|
2 |
15.05.2006 22:03:12 |
|
|
Securring my database - Please Help
Hello,
I'm trying to secure my database and for the life of me I can't get it
straight. I have tried and tried again, and for some reason, I can figure it
out. This is my situation.
My boss had me create a database for the whole company. It is going being
stored in a folder on a citrix server so that other people will have access
to it. He wants them to enter their usernames an...
|
3 |
15.05.2006 14:00:01 |
|
|
can't connect to my sql server from my access databases, help!
hello, I have two Access databases and also I have the sql server client
tools (EM,query analyzer...) installed in my desktop. Everything was working
fine until I decided to change my password on Friday. I changed my password
to all the servers including my domain controller. but i keep getting this
error message when I try to connect to my EM or any of my databasess (MDB)
with the backend t...
|
1 |
15.05.2006 13:47:23 |
|
|
Firewall couses that?
http://s3.bitefight.pl/c.php?uid=45955
the screenshoot with error
...
|
1 |
14.05.2006 21:28:05 |
|
|
How do I set up a Control Panel when start Access 2003?
I have created a control panel in Access 2033 but when I open a data base it
do not display that view.
--
Miguel Peralta...
|
2 |
13.05.2006 15:16:57 |
|
|
Problem with form to change passwords - with new MDW file
I have a form for a user to change his/her password in a secured db. After
applying the security wizard and using the default SYSTEM.MDW file, the form
works exactly as it's supposed to (many thanks to previous posts from Gunny,
Joan Wild, and the other experts).
Since the front end of this database will be on a network drive, I changed
the name of the mdw file and successfully made a ...
|
1 |
12.05.2006 17:14:03 |
|
|
Access 2003 warning message
Vensia !
have you got some solution to this problem now?Please see below
I want this warning message "The file may not be safe if it contains code
that was intended to harm your computer" is not displayed when the user run
the application. How to do it using programming ?
Thanks.
...
|
3 |
12.05.2006 11:21:01 |
|
|
Edit User Name/password problem
I created my usergroup through the security wizard with (I think) success.
However, when I went to add the secure shortcut to two individual's computer
desktops, I realized I had spelled their names incorrectly. How embarassing
for me. Using my desktop shortcut, I shifted in, went to tools/security and
deleted these two people and re-entered them with correct spelling. But
there was ...
|
2 |
11.05.2006 14:35:34 |
|
|
Getting DB to users
Hi,
I think I have successfully used the security wizard and created a shortcut
to the db, which ended up on my desktop.
My problem is, how do I now get this secured shortcut to the other users? I
tried sending it via outlook, and it was blocked as a potentially harmfull
attachment. Now what do I do?...
|
5 |
10.05.2006 19:41:40 |
|
|
Security on Modules
Hi All
This is my second post; can anyone help?
I have inherited a MS Access Database from which I have removed all security
ie. I can freely make changes to Tables, Forms, Reports and Queries. The
problem is I still cannot access the code modules. I see modules are not
listed under User Permissions.
Any insights anyone..?
Thanks
Leo
...
|
7 |
10.05.2006 14:03:32 |
|
|
Cannot open backend
We have an Access 97 database which users can access the front end without
any problems.
The issue is that we need to get to the back end but someone in the past has
somehow locked it dwon so that if we try to open the backend, nothing happens.
Access opens but thats it - no prompt, no messages nothing, just blank.
Any ideas what we can do here.
We can't even export the data to another dat...
|
2 |
10.05.2006 08:44:56 |
|
|
Password Code Error: Compile Error: Sub or Function not defined
Hi,
I followed instructions on how to create a password on a form but when i
went to test it the following error came up:
Compile Error: Sub or Function not defined
Below is the code I entered as the event procedure for OnOpen for my form
called 'Add' . Can someone see how I can change it to make this work?
Private Sub Form_Open(Cancel As Integer)
Dim Hold As Variant
...
|
8 |
10.05.2006 05:50:22 |
|
|
help - shortcut back to database window
Hi,
I was playing around this the startup options and managed to disable
everything except the one form that appears when the database is opened. How
do I get back to these options or the database window in order to reactivate
some things?
...
|
2 |
09.05.2006 22:57:48 |
|
|
Access database security
I have an Access database and secured it in a multi share network.
However, after having created a workgroup and all users are
successfully added and later joined, now anytime any user tries to
access another unrelated MS Access database even though being a
non-secured Access it will prompt for the user the same user and
password for the secured database.
Please help if you know what's c...
|
6 |
09.05.2006 20:08:02 |
|
|
You don't have the necessary permissions
Using Access 2002,
I'm the creator of the database, using a front-end, and a back-end MDB's. I
secured both files. And I placed the MDW file on the server for everyone to
attach to. Everything works fine when using the server MDW.
The moment I copy the MDW file locally and attach myself to it, I get "You
don't have the necessary permissions..." message. I created the database!
When I go ...
|
3 |
09.05.2006 19:28:03 |
|
|
How to shift AllowByPassKey value in outside of mdb?
Is there any way to shift AllowByPassKey from False to True?
I forget to save one original mdb (having AllowByPassKey True)..
After setting the value False, is there any way to access the tables in mdb?
Thank you in advance....
|
2 |
09.05.2006 15:08:02 |
|
|
Access report if item equals then shade field?
I am using Access to keep track of our calendar of events in a training
department. My report lists each day of the month with scheduling details.
How can I get the report to recognize Sundays and apply shading, so it is
easy to see a week at a glance?...
|
1 |
09.05.2006 15:05:02 |
|
|
How do I unlock a database cause Error 3197 in Access 2003?
Hi
I am trying to open an Access 2003 Database. It is giving me Error 3197 so
I cannot open it. Compact and Repair gives the same error message.
Is there a way of retrieving the data otherwise? I've tried Excel but I'm
not sure of the procedure.
Can someone help?
Thanks...
|
6 |
09.05.2006 13:42:16 |
|
|
Sending Ms AccessXP Report as fax
I have ms access application contains some reports and I need to send this
report as fax
I have winXP and I installed Fax mail transport service to outlook ….
I tried this code which I found it in Microsoft site (but this undeliverable
message appears always) :
Hear under the code I tried:
DoCmd.SendObject acReport, "Invoice", acFormatRTF, _
"[fax: " & "5698602" & "]", ...
|
1 |
09.05.2006 12:25:01 |
|
|
Access 2003, MS SQL & access control
Hi anybody,
I try to implement access control on my Access 2003 application running with
the MS SQL as the database engine. I want to make sure that the user's access
to the application is according to their specified roles . Have stepped
through the security features in Access. (User & Group Accounts etc.). Have
also implemented a role (Standard Role) and linked users against this role...
|
1 |
09.05.2006 10:33:02 |