Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Jason has attended:
Access Advanced course
Access VBA course

Access

What is the Access Jet engine?

RE: Access

Hi Jason

Thanks for your question and welcome to 12 months support from the forum.

The Microsoft Jet Database Engine is a database engine on which several Microsoft products were built. A database engine is the underlying component of a database, a collection of information stored on a computer in a systematic way. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.

JET stands for Joint Engine Technology, sometimes being referred to as Microsoft JET Engine or simply Jet. Microsoft Access and Visual Basic use or have used Jet as their underlying database engine. It has since been superseded, however, first by Microsoft Desktop Engine (MSDE), then later by SQL Server 2005 Express Edition and most recently by SQL Server 2005 Compact Edition, and no longer exists as a component of Microsoft Data Access Components (MDAC). For larger database needs, Jet databases can be upgraded (or in Microsoft parlance, "up-sized") to Microsoft's flagship database product, SQL Server 2005.

Over the years, Jet has become almost synonymous with Microsoft Access, to the extent where many people incorrectly refer to a Jet database as an "Access database".[citation needed] Even Microsoft themselves do this sometimes, but this nomenclature should always be seen as incorrect. Jet is a database and Access is a database application development tool.

hope this answers your question

regards

Best Team

Tue 14 Apr 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.