Stack Overflow
Stack Overflow

Questions tagged [jet]

Jet is the SQL database engine used by Microsoft Windows. It is also used by Microsoft Access. For Java Emitter Templates, see `java-emitter-templates` and `eclipse-jet`

Microsoft Jet is a SQL database engine that is used by the Microsoft Windows operating system.

It is an embedded database engine: just a library of functions used by applications that need SQL-based database functionality, with databases just being files on disk; just like SQLite or FireBird.

Jet databases usually have the extension .mdb. They are commonly known as Microsoft Access databases. This is because Microsoft Access, an application that provides a GUI frontend for creating and querying SQL-based databases, has always used Jet as its default database engine, and it is the de facto standard for examining the contents of an existing Jet database. However, Access can easily connect to other types of databases, and Jet databases can easily be used from other applications.

The latest version of Jet, used in Windows 7, is 4.0; the latest version of Access no longer uses Jet, but a successor with a different name, ACE.

For Java Emitter Templates, see

577 questions
230
votes
21 answers

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error "Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine ". So as a solution…
neo
  • 6,131
  • 6
  • 22
  • 27
41
votes
5 answers

Autonumber value of last inserted row - MS Access / VBA

I have a JET table with an auto-number as the primary key, and I would like to know how I can retrieve this number after inserting a row. I have thought of using MAX() to retrieve the row with the highest value, but am not sure how reliable this…
a_m0d
  • 12,034
  • 15
  • 57
  • 79
29
votes
7 answers

Table-less UNION query in MS Access (Jet/ACE)

This works as expected: SELECT "Mike" AS FName This fails with the error "Query input must contain at least one table or query": SELECT "Mike" AS FName UNION ALL SELECT "John" AS FName Is this just a quirk/limitation of the Jet/ACE database engine…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
23
votes
6 answers

Exporting MS Access Forms and Class / Modules Recursively to text files?

I found some code on an ancient message board that nicely exports all of the VBA code from classes, modules and forms (see below): Option Explicit Option Compare Database Function SaveToFile() 'Save the code for all modules to files…
leeand00
  • 25,510
  • 39
  • 140
  • 297
22
votes
9 answers

Why should I use SQLite over a Jet database

Someone asked me this the other day, and I couldn't think of a good answer. Platform portability is completely irrelevant to the project. In fact, Jet has some features that SQLite does not, namely foreign keys. So can anyone think why SQLite…
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
16
votes
4 answers

How fast is SQLite compared to Microsoft Access MDB?

Currently I'm thinking about replacing the usage of Microsoft Jet MDB databases on a single-user .NET C# Windows Forms application by a SQlite database. My goal is to lower installation requirements like the Jet drivers and some nasty errors when…
Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
16
votes
8 answers

Maximum number of rows in an MS Access database engine table?

We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally wired to be limited to fewer than some power of 2 of 4KB data pages). But what does this mean in practical terms? To help me measure…
onedaywhen
  • 55,269
  • 12
  • 100
  • 138
14
votes
13 answers

@@IDENTITY after INSERT statement always returns 0

I need a function which executes an INSERT statement on a database and returns the Auto_Increment primary key. I have the following C# code but, while the INSERT statement works fine (I can see the record in the database, the PK is generated…
Gillian
  • 141
  • 1
  • 1
  • 5
13
votes
4 answers

Accessing a JET (.mdb) database in Python

Is there a way to access a JET database from Python? I'm on Linux. All I found was a .mdb viewer in the repositories, but it's very faulty. Thanks
Honza Pokorny
  • 3,205
  • 5
  • 37
  • 43
13
votes
2 answers

Does Microsoft Jet DB work with Entity Framework?

In this forum here , someone mentions that Entity Framework does not work with Access (Jet DB - .mdb). However it seems that there is a provider for Jet DB as described here Which makes me think that the only thing I need with Entity Framework is to…
Saher Ahwal
  • 9,015
  • 32
  • 84
  • 152
12
votes
4 answers

Select Top (all but 10) from ... in Microsoft Access

Say I've got a query SELECT TOP 10 ... FROM ... ORDER BY ... in Access (well, really Jet). The question is: how can I get all the other rows... everything except the top 10?
Joel Spolsky
  • 33,372
  • 17
  • 89
  • 105
11
votes
4 answers

How can I get a list of tables in an Access (Jet) database?

I need to see if a table exists in an Access database used by my c# program. Is know there are SQL commands for other databases that will return a list of tables. Is there such a command for Access/Jet databases?
Jon B
  • 51,025
  • 31
  • 133
  • 161
11
votes
3 answers

How to determine if ACE or JET on windows machine using .net?

How to determine (for a machine running windows xp/vista/7) whether ACE or JET is installed, so I can use an appropiate connection string to connect to a access database.
willem
  • 2,617
  • 5
  • 26
  • 38
11
votes
11 answers

How to use LIKE condition in SQL with numeric field?

I'm using this query to get some specific data: "select * from emp where emp_name LIKE 's%'"; emp_nam is character field, how can I use the same logic condition with numeric field? something like: "select * from emp where emp_id ???? where emp_id is…
Mark
10
votes
4 answers

How to determine Jet database Engine Type programmatically

I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This enables use of SQL-92 syntax features) Upgrading is (relatively) easy. A call to the JRO.JetEngine object's…
MZB
  • 2,071
  • 3
  • 21
  • 38
1
2 3
…
38 39