Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2007

Reply Fri 25 Apr 2008, 15:27Delegate Anna said...

Anna has attended:
Access Advanced course

Access

How do you add a password to a split database?

For upcoming training course dates see: Pricing & availability

Reply Tue 29 Apr 2008, 10:45Trainer Carlos said...

Password on a Split Database

Hi Anna

Although you can add a password to the backend of a split database, I suggest suggest you split the database and then add the password to each of the front ends.

To add a password to a database:

1. Open the database as Exclusive (Select the database. In the Open dialog box Drop down the open button and select Open Exclusive

2. In the Ribbon, under Database Tools select Encrypt with Password and set the password

Hope this helps

Carlos

Reply Wed 30 Apr 2008, 11:18Delegate Anna said...

RE: Password on a Split Database

Thanks Carlos

Access articles

· A Quick Intro On How Access Uses SQL
· An Essential Guide To Using The Northwind Database In Access 2010
· Growing A Customer Base For A New Business - With The Help Of Access
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Happy Table Relationships In Access 2007

Please browse our web site to find out more about
microsoft access course and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips