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

"#" LIKE pattern character does not work in SQL in Access 365? A new bug in Jet SQL engine?

From wildcard characters supported by Microsoft Access I cannot get the # working in SQL statement. A minimalized example: SELECT COUNT(*) FROM MSysObjects WHERE "123" LIKE "#*" return value for "#*": 0 return value for "*": 56 It works only in…
miroxlav
  • 11,796
  • 5
  • 58
  • 99
3
votes
3 answers

How do I use my alias in the where clause?

I'm trying to search multiple columns of text and memos for certain phrases and blacklist phrases I don't want to see. Assume the following table stories: id, title, author, publisher, content Ex. I want to find all stories that mention (in any…
Raymond Berg
  • 860
  • 5
  • 17
3
votes
3 answers

How should I lock the table in this VB6 / Access application?

I'm working on a VB6 application using an Access database. The application writes messages to a log table from time to time. Several instances of the application may be running simultaneously and to distinguish them they each have their own run…
Brian Hooper
  • 21,544
  • 24
  • 88
  • 139
3
votes
2 answers

how to Select a Row in Oracle JET ojTable?

in the oracle jet quick basic example i have this table in dashboard.htm :
Ameur Baccoucha
  • 559
  • 1
  • 8
  • 17
3
votes
1 answer

Debugging Codeship build that runs fine with Jet

How should I debug a Codeship build that runs successfully with jet steps locally? I make sure to run it on a fresh checkout, so it starts in the same state as Codeship. My process is: Make fresh clone of repo Call jet steps --push --tag master…
Joseph Lust
  • 19,340
  • 7
  • 85
  • 83
3
votes
3 answers

Querying Jet Databases/Excel files with C# under x64 OS

So I have learned that that the Microsoft.Jet.OLEDB.4.0 data provider for querying data sources like Microsoft Access MDB files and Excel spreadsheets does not work under a Windows 64-bit operating systems. What I am now supposed to use to query…
Matthew Ruston
  • 4,282
  • 7
  • 38
  • 47
3
votes
1 answer

Delete 5 Records but RecordsAffected Property is 0

Here is a code snippet: Private Sub frmSearch_UnMarkAll() Const sqlD As String = "DELETE * FROM PickList WHERE TableName = ""CARS"" AND KeyNo IN (" & _ "SELECT RecNo FROM Cars " If frmSearch.WhereSql <> vbNullString Then CurrentDb.Execute sqlD &…
Perry Sugerman
  • 179
  • 1
  • 11
3
votes
1 answer

Why does the Excel source think my query has parameters?

Part of my current project involves converting an Excel 2007 spreadsheet having a number of tabs into an equal number of pipe-delimited flat files using an SSIS package. I've got one data flow task that opens up the excel file and selects the names…
Gorcq
  • 129
  • 1
  • 2
  • 10
3
votes
2 answers

How to combine two sql queries?

I have a stock table and I would like to create a report that will show how often were items ordered. "stock" table: item_id | pcs | operation apples | 100 | order oranges | 50 | order apples | -100 | delivery pears | 100 | order oranges | …
Plasmuska
  • 175
  • 3
  • 5
3
votes
4 answers

Where to find NHibernate Jet driver

I don't know if it's just me, but I just can't seem to find the NHibernate Jet driver anywhere. I have not yet looked into the source, but looking at the main project files or the NH Contrib files, did not give me any results. Enough time wasted,…
Bertvan
  • 4,943
  • 5
  • 40
  • 61
3
votes
2 answers

Get all field names in Microsoft Access Table using SQL

How do I get all the field names in a Table in Microsoft Access using JET SQL? Thanks all
Abs
  • 56,052
  • 101
  • 275
  • 409
3
votes
0 answers

COLUMNS_FLAGS field values for 'Columns' collection of OLE DB Schema Collections (ADO.NET)

I can't find COLUMN_FLAGS field values' enumeration for Columns collection of OLE DB Schema Collections (ADO.NET): Columns ColumnName DataType ... COLUMN_FLAGS Int64 for Microsoft.Jet.OLEDB.4.0 provider. Please post COLUMN_FLAGS field…
ShamilS
  • 1,410
  • 2
  • 20
  • 40
3
votes
2 answers

MS Access/accdb "Cannot open database" error (C#)

I'm using an MS Access database to store data for a desktop application. This week I was asked to give access to the application to some additional users, but whenever they launch the application they are getting the error message: Cannot open…
Jdinklage Morgoone
  • 770
  • 1
  • 7
  • 20
3
votes
4 answers

Access/jet equivalent of Oracle's decode

Is there an equivalent for Oracle's decode() in Access (or Jet, for that matter). The problem I am facing is: I should sort (order) a resultset based basically upon a status and a date (with all records having status = 2) at the end. In Oracle I'd…
René Nyffenegger
  • 39,402
  • 33
  • 158
  • 293
3
votes
1 answer

Save a query in an access database from C#

Since MS Access can save a query in the database file I assume there is a way to do this programmatically from C#. Any idea how?
Juan
  • 15,274
  • 23
  • 105
  • 187
1 2 3
…
38 39