Record Locking

Resolved · Low Priority · Version 2003

Record Locking

Bob has attended:
Access Advanced course

by - delegate Bob [1 post] (2008 May 28 Wed, 16:00) Reply

Is there ma problem with it

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Record Locking

by - trainer Carlos gold contributer [473 posts] (2008 Jun 11 Wed, 10:42) Reply

Hi Bob

Record Locking in tables takes place whenever someone access a record in a table

This prevents the situation where two users log onto the database, access the same record and begin to change it. This would corrupt the data.

Access uses a database engine (Jet) to avoid data corruption caused by simultaneous updates.

The database engine imposes locks on records as they're edited. A lock notifies the engine that someone is editing the record. It's up to the database engine to appropriately respond to the lock, which prevents data corruption.

So when a user access a record, Jet creates the .LDB file and makes entries in the LDB notifying other copies of Jet of the user's activities.

Hope this helps

Carlos

· How To Find Good Access Database Courses In London
· Microsoft Access 2007: New Features
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

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

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.