X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Set Up A Password For My Database, Access 2016    
post May 10 2018, 11:23 AM

Posts: 62
Joined: 29-January 17

I thought this would be easy, but I am going round in circles!
I need something for the General Data Protection Regulations coming into force on 25th May 2018

I was expecting to change my database so that when I tried to open it, the system would demand a password before I could go any further.

To do this I am told to :-
On the File tab, click Info, and then click Encrypt with Password.
When I do this
The help advises me that I need to open the database as exclusive.

To open exclusively using Access 365 (I believe this may be Access 16), I am told to
Close the database
Reopen by clicking the File Tab using the Open Command
In the Open Dialog box, click an arrow next to the Open Button
BUT ... my screen does not displays no arrows, just a list of database names.

I have spent the afternoon researching this an am left mystified.

Any ideas please.
Go to the top of the page
post May 10 2018, 11:33 AM

Access Wiki and Forums Moderator
Posts: 73,235
Joined: 19-June 07
From: SunnySandyEggo

I don't have O365. Can you post some screenshots while we're waiting for someone with the answer? We may be able to troubleshoot it after seeing what you're looking at.

Just a thought...

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
tina t
post May 10 2018, 12:01 PM

Posts: 5,518
Joined: 11-November 10
From: SoCal, USA

open Access. on the ribbon, click File, then Browse. this gives you the usual Open dialog box. navigate to the .accdb file you want to open. click the filename once to select it, then click the down arrow that's attached to the right side of the Open button in the dialog box. you'll get several options, one of which is Open Exclusive.


"the wheel never stops turning"
Go to the top of the page
post May 10 2018, 12:37 PM

UA Admin
Posts: 33,488
Joined: 20-June 02
From: Newcastle, WA

Following Tina's directions. Here's what it looks like.

Attached File  openexclusive.jpg ( 70.14K )Number of downloads: 4

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Visit My Blog on Facebook
Go to the top of the page
post May 12 2018, 04:38 AM

Posts: 62
Joined: 29-January 17

TheDBGuy, Tina t, GroverParkGeorge.

Many thanks for spending your time with me.
You have solved my problem.

I have now opened it exclusively.

I really don't know why I wasn't able to do it without bothering you.

Many thanks again. (The EU will be pleased)
Go to the top of the page
post May 12 2018, 04:51 AM

Posts: 62
Joined: 29-January 17

Attached File  Encryption_response.JPG ( 26.72K )Number of downloads: 1

Oh dear!

All went well ... I opened it exclusively .. I got the system to request passwords.
After entering and confirming the password, I got the attached response.

All seems OK with the database, but is it anything I need to worry about please?

P.S. I am the only user of the database.
There will never be two persons using it at the same time.

This post has been edited by MisterChips: May 12 2018, 04:53 AM
Attached File(s)
Attached File  Encryption_response.JPG ( 26.72K )Number of downloads: 3
Go to the top of the page
post May 12 2018, 05:50 AM

UtterAccess VIP
Posts: 6,063
Joined: 30-June 11

This is the standard warning that is displayed whenever you encrypt an Access database, nothing to worry about.

Be sure to save that password somewhere safe!

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
post May 12 2018, 06:09 AM

Posts: 62
Joined: 29-January 17

Many thanks Daniel.

I have the password, so does the Chairman and Club secretary.

Cheers. and thanks again
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th September 2018 - 05:30 PM