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
0
votes
1 answer

Why can't I use the field name as a parameter in an Access parameter query?

Working through some insert/update queries on an application today and came across a result I hadn't expected. Queries My insert queries look similar to this: PARAMETERS nm TEXT(10), st TEXT(2); INSERT INTO park(pname,…
NWdev
  • 483
  • 1
  • 6
  • 19
0
votes
0 answers

How to read CSV files with umlaut in the file name?

Using JET OleDB, how can I read a CSV file which has umlauts in the filename? The following example tries to read two different csv files (böse.csv and good.csv). The content of both files is the same, but the filenames are different. First a…
MiGro
  • 471
  • 1
  • 4
  • 17
0
votes
1 answer

Error while configuring data source setting in Jet report?

I have configured the Jet report with Excel 2013 and trying to connect with data source using Data source setting. I have NAV 2016 installed on my system. After giving Server and Server type, It is showing the correct list of databases available on…
Mogli
  • 1,972
  • 11
  • 34
  • 67
0
votes
1 answer

Select Distinct using JET and no PKEY - Duplicate rows

There seems to be a lot of threads on this topic but few that work with Excel. I have a simple table from which i want to select: ideally all columns i.e. using * if possible so if a user adds new columns they do not need to edit SQL. (is this a…
AndusM
  • 135
  • 5
0
votes
1 answer

Can we integrate PHP file in bigcommerce?

I want to fetch bigcommerce products to integrate it on jet.com. Through API, Products are successfully fetched from bigcommerce. But I created a PHP file in my local server for API. Now I dont know how can I use that PHP file in bigcommerce. Is…
Richest Singh
  • 11
  • 2
0
votes
1 answer

SQL Converting Vertical Column to Horizontal and Counting Values

I really need your help and it seems from an SQL standpoint that I can't seem to quite think like an SQL programmer with trying to obtain the following result set. Consider the following table below (which is a snapshot from my MS Access MDB…
BobbyJones
  • 1,331
  • 1
  • 26
  • 44
0
votes
0 answers

Search data between 3 conditions

I used to search in the database SQL. HTML:
Đức Hải - internet8x
  • 1
0
votes
0 answers

Query JET 4 database with SSIS

I want to use SSIS 2012 (2014?) to extract data from an old Access 2000 database once a month. The file is copied from a plant such that we have exclusive access to the file. We only want to read the data. On the development machine it works fine,…
Sparhawk
  • 1,517
  • 1
  • 14
  • 28
0
votes
0 answers

VbScript fails when trying to connect to Excel FIle with ADODB.Connection

My script fails when trying to connect to a 2010 excel file with an ADODB.Connection. I have read all about the 32 bit v 64 bit but still can't get it to work. Is there an easy way to connect to an excel file and grab some data with vb script...?…
Craigoh1
  • 169
  • 2
  • 3
  • 15
0
votes
1 answer

Create Iif() Statement or Query to check multiple values in multiples rows matched on ID

I am managing a student database. Each semester, we register students for their classes, and this progress is tracked in a table, [Registration Status Record]. Each row in the table consists basically of: [Student ID], [Semester], [Registration…
user4734199
0
votes
1 answer

SQL Select query isn't working with my Access Form

So I am doing a project where we are attempting to allow our user to open the form, select (via a combobox) an instructor, and then return all the students who have had that instructor over the years in a table. Without the WHERE clause the code…
Jake D.
  • 3
  • 3
0
votes
1 answer

Oracle Jet ojInputNumber component gives type="text"

Currently I am building a hybride app for android devices. I am trying to use the ojInputNumber component to force a numeric keyboard show up on the device. Unfortunately, the component binding always gives type="text". I have a list of objects…
Lai Ho Yeung
  • 1
  • 2
0
votes
0 answers

Optimum way to delete selected data from database

I have a huge database (nearly 7 million records). The schema is some what like this: tbl_Info: (ID, Name, ...) I have a ListBox which contains a number of items which can be related to the Name column of the tab_Info. The number of items present in…
Skaranjit
  • 764
  • 9
  • 26
0
votes
1 answer

How to refresh a MS Access linked table (with Excel file) programatically via C#?

I am trying to automate a process and thus need to programatically refresh a linked table in MS Access via C#. My table is already linked to myExcelFile.xlsx in a folder ../data/daily_inputs/, I just need to refresh it. I have googled for a solution…
Kangze Huang
  • 351
  • 7
  • 22
0
votes
1 answer

Show other field(s) associated with record retrieved with Access query MIN() function

I am using the following query: SELECT [ActionItems].AutoID, Min([ActionItems].[Action Status]) AS [MinOfAction Status] FROM [ActionItems] GROUP BY [ActionItems].AutoID; I have a custom sort set up for the field [Action Status], and this query,…
user4734199
1 2 3
…
38 39