Access 2007

Resolved · Urgent Priority · Version 2007

Wed 3 Apr 2013, 11:14 Delegate Astrid said...

Astrid has attended:
Access Introduction course
Access Intermediate course

Access 2007

I set up a password for my database this morning and am now struggling to access the document. Help please to de set the password.

I am in the office until midday today and would ask someone to call me on my direct line at 0208349 8969

Thanks

Thu 4 Apr 2013, 17:23 Trainer Simon said...

RE: Access 2007

Hi Astrid,

Thank you for your question and welcome to the forum.

The only way to retrieve a password is to download a program that will reveal the passwords.

http://www.freerecoverytools.com/file/recover-crack-unlock-access-mdb-accdb-database-file-lost-forgotten-password/

The link above is one option. This company or I do not recommend using such a program.

I hope this answers your questions.

Regards

Simon

Thu 11 Apr 2013: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds