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
-2
votes
2 answers

Selecting data from csv

i want to select data from csv file here is my code var filenamecsv="D://Data.csv"; adoConn1.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\; Extended Properties='text;HDR=Yes;FMT=Delimited';"); adoRS1.Open("Select * From…
umair
  • 9
  • 1
-2
votes
1 answer

Access SQL Issue

I am curious if there are any experts in Access' version of SQL that could help me decode the below? I am not great in Access and try use SSMS but I am taking over an already built report. Thanks! LT CRD: IIf(Day(Date()+[IAM_MAN_LEAD_TIME])…
user3496218
  • 185
  • 3
  • 5
  • 19
-2
votes
1 answer

Use SQL Server Express engine in MS Access

Is it possible to use SQL Server Express engine with MS Access? The reason, why I am asking is, that I want to get rid of Jet/ACE engine and the limitation of 2GB per db file. Thank you for your feedback, Cralevic
cralevic
  • 17
  • 2
-3
votes
1 answer

ModuleNotFoundError: No module named 'jet'

im trying to run a project at https://github.com/VladKha/MovieNet but i keep getting the error even after pip install jet multiple times Exception in thread django-main-thread: Traceback (most recent call last): File…
rajan
  • 95
  • 2
-3
votes
4 answers

Reading from Excel sheet

I have written the code below to read data from an Excel sheet and display data in a combobox in Visual Basic. However, when I click "run" nothing is displayed. Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles…
nesreen
  • 33
  • 1
  • 6
-3
votes
1 answer

Inserting variable along with data from select

I have a query that currently inserts data from one table into another table, moveQuery = "INSERT INTO results(ClassCode, AttemptDate, StudentID, Mark) SELECT F1,F2,F3,F4 FROM " & randtablename & " where F1 = '" & classcode & "'" I'd like to…
user976007
  • 35
  • 1
  • 5
-4
votes
1 answer

MS Access Jet Database programatically compact

Ref: Access "Compact and Repair" programatically HI Guys, I'm looking for a way to run a batch script via scheduled task to compact and or repair a "Jet" .mdb file / database. Environment Win 7 32 bit Jet 4.x format application.exe Original code…
Vincent Mills
  • 1
1 2 3
…
38
39