|
fastest way of distributing a split and secured database
I have a split and secured Access database:
database_BE.mdb + workgroup file (network location)
database_FE.mdb (mde) - local copy for each user
shortcut (/wrkg ...)
where,
BE - back end
FE - front end
What is the most convenient way to distribute shortcut + database_FE to each
user?
The below described distribution ways seem to be either labour-consuming or
rather not very practic...
|
2 |
1/1/2009 1:31:15 AM |
|
|
Using logon name and password within a form
Is it possible to:
A) use a logon password to determine a user's level of access or approval
limit within a form? I have a form that allows users to approve paybacks of
deductions, but different users have different levels of approval $ limits.
Can the password they entered upon opening the database disallow them to go
over their appointed limit? I would also like to have a switchboa...
|
1 |
12/31/2008 1:49:00 PM |
|
|
Exclusive Notice On Opening mdb
Access 2002 under Windows XP Pro with all patches.
On a split db with user-level security in place and working
well, the users in a custom, non-admin group always get a
message when the log on to the mdb:
"You don't have permission to open '[pathname]' for
exclusive use."
They all use a custom shortcut to open the db, and the
shortcut doesn't use the "/Excl" argument. Folks in that...
|
6 |
12/30/2008 11:59:29 PM |
|
|
Forgotten password and reloading Access
I have created a database on my computer at work using Access 2003. I forgot
the Admin password. I can load the same database onto another computer and
I am able to enter as the Admin without using a password.
I've seen postings that talik about changing the system.mdw, but would like
to get a questioned answered before I try anything.
I only have the one database on my computer and...
|
3 |
12/30/2008 6:36:01 PM |
|
|
firewall
Hi hope someone can help. i am a novice running a Compaq Presario Desktop
with OS Windows Vista Home premium. As I understand it Windows comes with a
firewall but I have heard some people say that it is not sufficient and to
have at least two firewalls. Is this true and if so what is a simple free
firewall to get? Any help would be appreciated. TIA
Raymond
...
|
2 |
12/30/2008 5:33:18 PM |
|
|
Question About the Security FAQ
In the MS Access Security FAQ (11/22/2006), in the first
item in the Table of Contents, "What are the steps to secure
a database?", the first paragraph, last sentence states:
"You may elect not to use the Security Wizard and to secure
the database manually by following these steps."
Steps 1 thru 6 seem logical enough, but in step 7...
"Open the database that you want to secure and run ...
|
1 |
12/29/2008 6:33:25 PM |
|
|
I'm drawing a blank...
Well, I'm not, but Access is.
I'm using the built-in ULS in Access 2003. I have full administrative rights
and I'm also the owner of the db. My problem is that when I log in as a user
with "Open/Run" rights only I can't see the form. It comes up with the Title
bar and a gray form with no controls on it. i double checked and all of the
controls are set to visible always. I've tried diff...
|
3 |
12/29/2008 6:14:30 PM |
|
|
Sharing & Read Only
How can I get a database to open - not in read only? I have 2 machines
running Access 2007, but one that has 2000. I need to have the database be a
2000 so all machines can run it. Since I purchased the new machine running
vista, it will not let me keep the database as 2000 and allow non read only.
I set permissions to let everyone do everything.
Having a terrible time with sharing....
|
2 |
12/27/2008 3:54:57 PM |
|
|
User in Admin Group Can't Modify Objects
Access 2002 under Windows XP, all patched.
Split db with user-level security applied and working well.
The front-end that I routinely pass around was getting a bit
bloated with a bunch of analysis tables and queries, so I
made a copy and renamed it. Then I copied it to the machine
of another user who is a member of the admins group.
When he opens the database with a modified shortcut ...
|
16 |
12/24/2008 8:15:17 PM |
|
|
Weird Behavior on connecting
Hello,
Using a simple, barebones .NET 2.0 application (C#), I am trying to connect
to a simple encrypted Access 2007 database in the same directory, like so...
oleMyDbConnection = new System.Data.OleDb.OleDbConnection();
oleMyDbConnection.ConnectionString =
"Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=abc;Data
Source=TestDatabase.accdb;Persist S...
|
1 |
12/23/2008 7:44:56 PM |
|
|
Access 97 Security Dilemma
Hello!
We need to implement a user-level database security. However, we need to use
two files of type .MDW as follows:
1) Closed Security - To avoid linking tables between databases,
import/export of objects and so on - Default one. This will be only valid
when opening Microsoft Access Application without the Database Application.
2) Open Security - To allow users to open the existing...
|
4 |
12/23/2008 6:08:08 PM |
|
|
Can't read queries in Access 2003
I am running Access 2003 SP3. I am new to the company and am trying to fix a
problem on a file that was created by the last guy here. The one person who
uses the db had no problems until she migrated to a new laptop. Now she
cannot run any of the queries. It does not appear to have any security
enabled - no specific users or groups other than the standard Admin and User.
All objects...
|
2 |
12/22/2008 9:42:33 PM |
|
|
Unable to Turn off Sandbox mode
I am getting the standard security warnings when I open any of my Access 2003
database. So I went into the Macro/Security option and turned the security
warnings to low. Now when I reload the database its like I did nothing at
all; the warnings are back and the setting is back to medium.
I thought that I could get around this by editing the sandbox option
directly in the registry at
...
|
5 |
12/22/2008 6:27:06 PM |
|
|
Making MDE
I have created a bibliographic database using Access 2003. I want to make a
mde file for this. But I was not able to do that. I got an error message
showing the reason of too many number of TableId used and so many number of
forms. This database contains only 5 tables, 1025 queries and 72 forms. What
should I do?
With best regards.
--
nandini...
|
3 |
12/22/2008 3:44:34 AM |
|
|
HYPERLINK
I'm not sure if this is the right area to ask this question so here it is.
I have a field in a form that is designated as hyperlink. This hyperlink
goes to a sub directory. The system is not networked or anything. It's a
standalone.
The problem is when you click on the link I now get a message:
Hyperlink can be harmful to your computer and data. To protect your
computer, click o...
|
2 |
12/21/2008 9:57:00 PM |
|
|
disable field/control on form (dependent on user/group)
Hello,
Is there a way to disable a field(s) on a form when a user from a certain
group is logged in (not a single user)?
If the function "currentUser()" is used, every time a new user is added vba
code must be modified which is not very convenient.
Thank you for suggestions.
...
|
2 |
12/21/2008 4:34:29 PM |
|
|
CreateWorkspace does not work for me
I'm going crazy on the below code not working anymore. I have used this in
the past without any problem. Recently I wanted to implement again and for
one reason or another, it seems the systemDB is not assigned correctly.I'm
getting the error 'Not a valid account name or password'. When debugging, the
SystemDB returns the default Access security group instead of the one I'm
trying to ass...
|
7 |
12/20/2008 12:17:01 AM |
|
|
Capture NT username
There is a post & answers: Subject: Capture NT username for form * 6/2/2005
8:25 AM PST
....That asks exactly what I need:
In my Access Database I would like to pull the NT Username and store the
username (their network login name) in a field on the record the user is
entering or modifying. Unfortunately, I do not know VB at all. I can get as
far as copying the VB to a new module in ...
|
5 |
12/19/2008 11:01:04 PM |
|
|
problem with trusted database
I have a database that was originally created in 2000. I am opening it in
2007. I have set the folder as a Trusted Location, i have even changed the
registry value to the lowest security setting. Yet, the controls on my forms
are still disabled and do nothing. I followed MS instructions for enabling
the Message Bar, yet it still shows as disabled. I am at a loss for why this
won't work?...
|
1 |
12/19/2008 5:29:01 PM |
|
|
Shared database
Our office recently upgraded from Office 2003 to Office 2007
A month after the upgrade, access 2007 crashed and had to be restored from
backup tapes. Since then 2 of 5 users get READ ONLY access to the database.
How do I restore the frontend access to these users?...
|
3 |
12/19/2008 5:01:00 PM |
|
|
Help with Splitting and Security Issues
Hi Everyone!
I got several issues here and I really need a Step-By-Step Instructions on
the following please!! BTW the database will be placed on a network and used
by several people.
1. I've split my database. Now I have a backend Db with only tables on it.
Where are the other objects (i.e, forms, queries, reports)? Is the backend
Db only used by the Admin? If so, why do I not h...
|
3 |
12/18/2008 3:11:51 PM |
|
|
Access 07 password
Access 07 states that use of a password also includes database encryption for
an ACCDB file. Nothing is said about a ACCDE file. What I want is to have a
password to open an ACCDE database with no database encryption just as I had
with Access 2000. Is this possible? What comes with the use of a password for
an ACCDE file....any encryption?
Thanks for your help>...
|
2 |
12/17/2008 2:08:46 PM |
|
|
User has permissions to object, but denied exclusive access
I've been having this problem for a while now and I'm at my wits end.
I created a database a few years ago with USL. I've added my name to the
Admin and Full Permissions groups. I am the owner of most of the objects.
But when I try to open the database in "exclusive", I get "Not a valid
account name or password". But when I open the database via the shortcut,
using the same account ...
|
1 |
12/12/2008 7:31:04 PM |
|
|
Permissions on table object
I created a form for a select few people to create basic (throwaway) user
accounts. The code creates a user, adds it to the default users group, a
custom "LineStaff" group, and optionally a "NotherGroup". If I log on using
any account but my Administrator account, the following error is generated:
You do not have the necessary permissions to use the 'Tables' object. Have
your system adm...
|
2 |
12/12/2008 5:28:22 PM |
|
|
Who's Online?
Hello everyone,
What is the best way to determine who is logged into an Access Dbase through
ULS? I need to know which user is logged in so that I can determine which one
of 7 locations to list as their location id. Is it possible to put
information like that into their security permissions? I'm using the Access
User Level Securities, because it would be easier for someone who has never
...
|
6 |
12/11/2008 9:45:08 PM |