473,383 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

MS Access Security help

Hello anyone who can help

I'm a novice at access, and have a fairly large database that I'm trying to change the password on. I keep getting the message that it's not set for exclusive use.
This is a pretty easy one for you folks I'm sure, but I'm not getting anywhere with it.

Basically I'm looking to completely remove all security settings, and just re-do it with the security wizard. Have a few access books the company bought, but None of them are of any assistance here.

When I try to change the password, it doesn't recognize the old one, even though I typed it exactly in order to open the database in the first place. Strange things.

Can anyone help out?
I would be most appreciative.

thanks
-JM
Nov 30 '07 #1
3 1222
puppydogbuddy
1,923 Expert 1GB
Hello anyone who can help

I'm a novice at access, and have a fairly large database that I'm trying to change the password on. I keep getting the message that it's not set for exclusive use.
This is a pretty easy one for you folks I'm sure, but I'm not getting anywhere with it.

Basically I'm looking to completely remove all security settings, and just re-do it with the security wizard. Have a few access books the company bought, but None of them are of any assistance here.

When I try to change the password, it doesn't recognize the old one, even though I typed it exactly in order to open the database in the first place. Strange things.

Can anyone help out?
I would be most appreciative.

thanks
-JM
I am not familiar with that message you are getting, so I can't help you there. However, this link may help you diagnose and solve your problem.

http://support.microsoft.com/kb/235961
Dec 1 '07 #2
Johan,

To open the database exclusively in order to change the database password - launch Access first, then click File ~ Open, navigate to your Access file and then notice that the Open button has a small drop-down at the right edge - select Open Exclusive.
Dec 1 '07 #3
Awesome. Thanks! It's always the little things...
-jm
Dec 3 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Mark Thiel | last post by:
I am working on a project for my company, which has a structure of six major areas. Certain people need to have access to all of the data, whereas other people only require access to the...
5
by: Greg Strong | last post by:
Hello All, What are the best ways to implement security for Access databases (i.e. ..MDB files)? I ask the question from a general perspective. Why? Well I had written a prototype database...
0
by: Namratha Shah \(Nasha\) | last post by:
Hey Guys, Today we are going to look at Code Access Security. Code access security is a feature of .NET that manages code depending on its trust level. If the CLS trusts the code enough to...
29
by: Patrick | last post by:
I have the following code, which regardless which works fine and logs to the EventViewer regardless of whether <processModel/> section of machine.config is set to username="SYSTEM" or "machine" ...
11
by: Josh Flanagan | last post by:
I am trying to write to the event log from ASP.NET, on Windows XP SP1. As soon as I try to write an event (or even query the source with EventLog.SourceExists() or EventLog.LogNameFromSourceName())...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
1
by: cpajoe2001 | last post by:
I am having an issue and after searching around online for a day and half now and finding others with the same problem but yet no solution to my issue I am looking for help. What i have is ServerA...
22
by: teejayem | last post by:
Hi, I am new to programming with databases and was wanting some help. Is there any way to password protect an access database and access sent sql commands to it via vb.net code? Any help...
7
by: thebarefootnation | last post by:
Hi, I have created an access db that I would like to secure. The database will exist on a shared drive and be used at a number of different locations hence the reason to secure the database. ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.