patjones 931
Recognized Expert Contributor
Good Evening:
So, I wanted to learn a little about user accounts, because on of my databases has been put on a network drive, and I have a need to know who is entering what data into the application. I figured one easy way to do that would be to just create a user account for everyone and copy to the table "CurrentUse r" each time a new record is added. Then I'll know who added the record.
To learn this, I went to another site with a tutorial about this stuff and stupidly downloaded a sample database (which happened to have an .mdb file extension, i.e. earlier than Access 2007) which was designed to teach about user accounts and permissions.
So I played around with this database for a while, created some users, set some permissions and passwords, worked with user groups, etc. and everything worked fine.
Then, later on, much to my surprise, when I completely closed out of Access and opened my own project, it asked me for a password with my username that I created in the other database. What's more is that when I got into my project, I found that I was completely locked out of the user accounts and permissions part of the "Database Tools" menu - I couldn't change anything.
Finally then, my question is this: when you make such changes in one project, aren't they supposed to be local to that project? It seems like the changes I made affected Access as an application, period. What is going on here? Thank you...
1 3909 nico5038 3,080
Recognized Expert Specialist
Guess this tutorial will answer your questions:
[url]http://www.moretools.c om/lessons/access_security .htm[url]
Personally I never use this and I guess you found out why :-)
Nic;o)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: JJ_377 |
last post by:
I can get the debugger to work: I get a message:
"sp debugging may not work if you log as as Local System Account" while
SQL Service is configured to run as a service. You can open Event Viwer
to see details." (Viwer means "Viewer" this is not one of my typos...)
My text book says that this message means there is a problem that can
be fixed in the SQL Server registration node (just under the server
group in Enterprise Manager),...
|
by: Jeff MacDonald |
last post by:
Hi,
WHen i run pg_dumpall as the super user it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without passwords ?
Thanks.
Jeff.
|
by: MLH |
last post by:
I was running the following code while logged
in as a user belonging only to the Users group.
Set usrNew = .CreateUser(Me!UserID) 'The user ID is in a
control on the form
usrNew.PID = "AAA123456789"
usrNew.Password = "password"
.Users.Append usrNew
|
by: Salad |
last post by:
The other day my friends were on the web ready to purchase some tickets
on-line for a concert. There was a textbox to enter their e-mail
address and another to enter a password. So they entered their e-mail
address and promptly entered their password to their Yahoo email account
and submitted it.
The web server fortunately kicked it out and said "Invalid Email
Account". They had done this several times so they asked me for help.
I...
|
by: Jefferson Cowart |
last post by:
I'm writing a program for a college to use to allow students to register their computers for use on the network. Aside from a bunch of security related checks I would like the program to offer to store the users network username and password so when they access network servers they are not prompted for their username every time. I can do it manually through the user accounts control panel -> Advanced Tab -> "Manage Passwords" button, but...
| |
by: BookerW |
last post by:
Ok interesting, on my local machine
And i did not do a good job of keeping track of the exact order....
but on my local machine
in which i have vis studio 2003 installed and IIS for win XP,
I copied the web.config file from the source code folder into the
inetpub\wwwroot folder b/c that is where the ASP engine was looking for it.
|
by: BookerW |
last post by:
I am not sure which forum I should post this on, but here is the problem. I
have a front end web application(VB) on asp,net 1.1 framework. Inside of the
code, I have the following lines to connect to the database
If gbSQLServer Then
'sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\w\vgyl\hy.mdb"
gsConnectionString = "Provider=SQLOLEDB;Data Source=frt4;Initial
Catalog=SRMSM;Integrated Security=SSPI"
Else
|
by: Matuag |
last post by:
Hi All,
Is there anyway we can create different Usernames, user levels and
passwords in Access 2007? I could not find any icons for this on the
ribbon.
I have created Notes History using
=ColumnHistory(,"Notes","=" & Nz(,0))
which returns
|
by: =?Utf-8?B?cnZhbmdlbGRyb3A=?= |
last post by:
Hello,
I have a problem with our OnlineBackupService.exe. This is a Windows Service
which is built in .Net 1.1 and basically grabs files from the file system and
will try to upload them using WebServices.
The service is installed by default using LocalSystem account. The exact
problem is that sometimes this service is not allowed to resolve the target
webservice. This results in the following exception:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |