Microsoft/Access - Revision history

Woozle: Woozle moved page Microsoft Access to Microsoft/Access: organizational convention

2026-01-22T20:49:12Z

Woozle moved page Microsoft Access to Microsoft/Access: organizational convention

← Older revision	Revision as of 20:49, 22 January 2026
(No difference)

Woozle: screenshot of continuous form

2022-12-03T17:08:40Z

screenshot of continuous form

← Older revision		Revision as of 17:08, 3 December 2022
Line 5:		Line 5:
	[[category:Microsoft]]		[[category:Microsoft]]
	</hide>		</hide>
			[[File:continuous-form-gs4.gif\|thumb\|an example of a [[continuous form]] in MS Access]]
	==About==		==About==
	[[Microsoft Access]] is a software application published by [[Microsoft]] that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records. Access projects use the [[.mdb]] file extension for storing data and other project information, and [[.ldb]] for file-locking data.		[[Microsoft Access]] is a software application published by [[Microsoft]] that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records. Access projects use the [[.mdb]] file extension for storing data and other project information, and [[.ldb]] for file-locking data.

Woozle: format updating & tidying

2019-10-11T19:35:56Z

format updating & tidying

← Older revision		Revision as of 19:35, 11 October 2019
Line 1:		Line 1:
	~~==Navigation==~~		<hide>
	<~~section begin=navbar /~~>~~{{#lst~~:~~Microsoft Office\|navbar}}~~: [[Microsoft ~~Access\|Access~~]]<~~section end=navbar~~ />		[[page type::article]]
	==~~Overview~~==		[[thing type::software]]
	[[Microsoft Access]] is a software application that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records.~~{{seedling}}~~		[[category:software]]
			[[category:Microsoft]]
			</hide>
			==About==
			[[Microsoft Access]] is a software application published by [[Microsoft]] that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records. Access projects use the [[.mdb]] file extension for storing data and other project information, and [[.ldb]] for file-locking data.
	==Related Pages==		==Related Pages==
	* '''Versions''':		* '''Versions''':
Line 8:		Line 12:
	* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition\|Professional Edition]] [[office suite]], though it can also be purchased separately		* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition\|Professional Edition]] [[office suite]], though it can also be purchased separately
	* [[MS Access and MySQL]]: using MS Access with [[MySQL]] as a back-end		* [[MS Access and MySQL]]: using MS Access with [[MySQL]] as a back-end
			==Links==
			* {{wikipedia}}

Woozle: /* Related Pages */ linking to "MS Access and MySQL" anchor page

2008-11-09T01:41:38Z

Related Pages: linking to "MS Access and MySQL" anchor page

← Older revision		Revision as of 01:41, 9 November 2008
Line 6:		Line 6:
	* '''Versions''':		* '''Versions''':
	** [[Microsoft Access 97]] (8.0)		** [[Microsoft Access 97]] (8.0)
	* [[using MySQL with MS Access]]
	* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition\|Professional Edition]] [[office suite]], though it can also be purchased separately		* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition\|Professional Edition]] [[office suite]], though it can also be purchased separately
			* [[MS Access and MySQL]]: using MS Access with [[MySQL]] as a back-end

Woozle: updated navbar and one or two tweaks

2008-08-17T17:16:34Z

updated navbar and one or two tweaks

@@ Line 1: / Line 1: @@
 ==Navigation==
-[[computing]]: [[software]]: [[Microsoft]]: [[Microsoft Office|Office]]: [[Microsoft Access|Access]]{{seedling}}
+<section begin=navbar />{{#lst:Microsoft Office|navbar}}: [[Microsoft Access|Access]]<section end=navbar />
-[[Microsoft Access]] is a software application that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)|IDE]], and forms designed to allow easy display and editing of database records.
+==Overview==
 ==Related Pages==
 * [[using MySQL with MS Access]]
-* [[Microsoft Access]] is part of the [[Microsoft Office]] Professional Edition [[office suite]], though it can also be purchased separately
+* [[Microsoft Access]] is part of the [[Microsoft Office]] [[Microsoft Office Professional Edition|Professional Edition]] [[office suite]], though it can also be purchased separately

Woozle: /* Related Pages */ MS Office

2007-07-17T01:31:00Z

Related Pages: MS Office

← Older revision		Revision as of 01:31, 17 July 2007
Line 4:		Line 4:
	==Related Pages==		==Related Pages==
	* [[using MySQL with MS Access]]		* [[using MySQL with MS Access]]
			* [[Microsoft Access]] is part of the [[Microsoft Office]] Professional Edition [[office suite]], though it can also be purchased separately

	==Bugs==		==Bugs==
	The following applies to Access 97 and may not apply to later versions:		The following applies to Access 97 and may not apply to later versions:

Woozle: /* Weaknesses */ clarifications

2007-07-17T01:28:38Z

Weaknesses: clarifications

← Older revision		Revision as of 01:28, 17 July 2007
Line 11:		Line 11:
	==Weaknesses==		==Weaknesses==
	The following apply to Access 97 and may not apply to later versions:		The following apply to Access 97 and may not apply to later versions:
	* Although it is possible to ~~write functions to~~ translate source data into a different ~~display~~ format, it is not possible to ~~write~~ corresponding ~~routines~~ to ~~translate~~ user data~~-entry~~ back into ~~source~~ data. It is not possible, therefore, for the user to edit data in a form or query if it has been manipulated in certain ways, including fields in queries above a certain level of complexity as well as any data which is the result of a function.		* Although it is possible to have a function translate source data (stored in a recordset) into a different format and have the resulting value shown automatically on a form field, it is not possible to have a corresponding routine to accept user-entered data and translate it back into data for storage in the table. It is not possible, therefore, for the user to edit data in a form or query if it has been manipulated in certain ways, including fields in queries above a certain level of complexity as well as any data which is the result of a function.
	* Data from some sources (tentatively: queries of a certain complexity or higher, or possibly certain types of JOINs) cause data in continuous forms to be formatted improperly. The user has to manipulate the form in certain ways in order to restore the display.		* Data from some sources (tentatively: queries of a certain complexity or higher, or possibly certain types of JOINs) cause data in continuous forms to be formatted improperly. The user has to manipulate the form in certain ways (scroll to the end, scroll back, hide and reveal the window) in order to restore the display.
	* There are no tools for recovering data from a corrupted database file (.mdb)		* There are no official tools for recovering data from a corrupted database file (.mdb)
	* There appears to be a limit on the number of tables/queries which can be open simultaneously. This number is never stated outright, but if you try to open too many forms ~~in an application written in Access,~~ a message pops up saying "can't open any more databases", and some of the fields on the last form opened may be empty or display improperly.		* There appears to be a limit on the number of tables/queries which can be open simultaneously. This number is never stated outright, but if you try to open too many forms a message pops up saying "can't open any more databases", and some of the fields on the last form opened may be empty or display improperly.
	===Minor Annoyances===		===Minor Annoyances===
	* Text formatting in stored Query objects is not preserved.		* Text formatting in stored Query objects is not preserved.

Woozle: tidied up navbar

2007-01-16T19:02:18Z

tidied up navbar

← Older revision		Revision as of 19:02, 16 January 2007
Line 1:		Line 1:
	[[~~Computing~~]]: [[~~Software~~]]: [[Microsoft Access]]{{seedling}}		==Navigation==
			[[computing]]: [[software]]: [[Microsoft]]: [[Microsoft Office\|Office]]: [[Microsoft Access\|Access]]{{seedling}}
	[[Microsoft Access]] is a software application that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records.		[[Microsoft Access]] is a software application that combines a [[database engine]], a programming language ([[VBA]]) and [[IDE (programming)\|IDE]], and forms designed to allow easy display and editing of database records.
	==Related Pages==		==Related Pages==

Woozle: /* Bugs */ lookup lockup

2006-12-26T01:35:31Z

Bugs: lookup lockup

← Older revision		Revision as of 01:35, 26 December 2006
Line 6:		Line 6:
	The following applies to Access 97 and may not apply to later versions:		The following applies to Access 97 and may not apply to later versions:
	* '''Scroll Wheel Juggernaut Mode''': If you accidentally move the scroll wheel while displaying a data form in single-record mode (i.e. not "[[continuous forms]]" mode), Access starts going through the records one by one until it gets to the first or last record (depending on which way you scrolled); this can take quite awhile, depending on the size of the recordset being displayed and the rendering time for each current record. It cannot be interrupted in any way, except by invoking the [[Windows Task Manager]] (ctrl-alt-delete) and killing the process for Access. Ctrl-C and Ctrl-Break have no effect.		* '''Scroll Wheel Juggernaut Mode''': If you accidentally move the scroll wheel while displaying a data form in single-record mode (i.e. not "[[continuous forms]]" mode), Access starts going through the records one by one until it gets to the first or last record (depending on which way you scrolled); this can take quite awhile, depending on the size of the recordset being displayed and the rendering time for each current record. It cannot be interrupted in any way, except by invoking the [[Windows Task Manager]] (ctrl-alt-delete) and killing the process for Access. Ctrl-C and Ctrl-Break have no effect.
			* '''Lookup Lockup''': If the query used to look up a value in a table view is too complex (e.g. includes a union), the table view will become "read-only".

	==Weaknesses==		==Weaknesses==
	The following apply to Access 97 and may not apply to later versions:		The following apply to Access 97 and may not apply to later versions:

Woozle: /* Weaknesses */ bugs: scroll wheel juggernaut mode

2006-12-11T16:36:52Z

Weaknesses: bugs: scroll wheel juggernaut mode

← Older revision		Revision as of 16:36, 11 December 2006
Line 3:		Line 3:
	==Related Pages==		==Related Pages==
	* [[using MySQL with MS Access]]		* [[using MySQL with MS Access]]
			==Bugs==
			The following applies to Access 97 and may not apply to later versions:
			* '''Scroll Wheel Juggernaut Mode''': If you accidentally move the scroll wheel while displaying a data form in single-record mode (i.e. not "[[continuous forms]]" mode), Access starts going through the records one by one until it gets to the first or last record (depending on which way you scrolled); this can take quite awhile, depending on the size of the recordset being displayed and the rendering time for each current record. It cannot be interrupted in any way, except by invoking the [[Windows Task Manager]] (ctrl-alt-delete) and killing the process for Access. Ctrl-C and Ctrl-Break have no effect.
	==Weaknesses==		==Weaknesses==
	The following apply to Access 97 and may not apply to later versions:		The following apply to Access 97 and may not apply to later versions: