Linked tabled Protect
Tue, 26 Aug 2008 10:31:02 -0700
Here is my problem. I have a linked table that is used for many different
databases as a way for the users to log into the database. The table contains
the username, password, and computer name. I have a user that is unset that
the log in information is able to be view by anyone that knows how to get to
the ...
|
Lockdown Database
Tue, 26 Aug 2008 08:41:01 -0700
I have been working on a 2003 database and now need to hand the process over
to someone. They need to be able to run pre-written and form controlled
queries etc for updates/make tables/select etc.
I do however want to take away any ability for them to view queries and/or
amend them or forms etc.
Thanks ...
|
Query Passwords
Mon, 25 Aug 2008 08:50:01 -0700
Is there a way to set that a password be given to run a specific query. I
have a database with financial information that a select group of people have
access. But I only want a couple people to have access to one specific query. ...
|
Setting up security in a database
Sat, 23 Aug 2008 23:28:01 -0700
Can anyone direct me to a simple Guide for setting up Access database
security? I have read the Help files, referred to the following MS site
http://support.microsoft.com/kb/289885/en-us
and searched this forum.
The more I read the more confused I get. The MS site seems to say that I
should have set up the ...
|
Opening an old database to edit reports
Sat, 23 Aug 2008 09:22:01 -0700
I want to open an old database i created last year, but i changed the
settings to stop the user changing anything. How do i open it again so i can
edit some of the reports? I seem to remember its Ctrl and something..
--
Claire ...
|
Problem using Access in Active Directory
Fri, 22 Aug 2008 14:47:02 -0700
Has anyone else had issues with Access when you logoff local user and login
to Active Directory?
System info:
Front end: Windows XP, Service Pack 2
Back end: SQL Server 2003
Access 2007
Event: I have been running quite successfully an application built with VBA
and macros. I have had no problem runn ...
|
Permanently hide table
Fri, 22 Aug 2008 16:19:46 -0500
Hello,
I am creating a standalone Access application. I save the application as
.mde. How can I hide the table so that people will not see them. I want to
permanently hide them. Is there a way to lock, or encrypt the table? To be
clearer, I want users just click on the form and have no access to tables.
...
|
|
|
>> SQL admin member
Thu, 21 Aug 2008 16:04:00 -0700
Hi, using Access 2003 how can I check whether a user is a member of the
back-end sql database admin group?
Many thanks,
Jonathan ...
|
BackEnd Database Locking when FrontEnd runs a query - why?
Thu, 21 Aug 2008 15:29:02 -0700
The simple question is,
Why does a select query using the IN command lock the target database?
I am trying to write a reporting app where the users have a fairly skinny
frontend on their local machine. The frontend has tables that are linked to
a backend database that drive the application.
In the bac ...
|
1 user gets when "admin" in use - but no login/password prompt
Wed, 20 Aug 2008 16:10:08 -0700
I have a user that when we click on the shortcut to the secured database they
get don't get the login / password prompt box... Instead a message saying
Cannot login when "Admin" in use... when you click "OK" reverts to ACCESS...
However, all the other users of this database do not have this issue... The
Logi ...
|