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

How do I create an OLEDB table with the column named "DATE"?

We're using the Microsoft Jet OLEDB provider to insert data into a legacy system. This system requires that we insert data by creating a DBF file, which has the format of: employee Numeric (10,0), jobcode Numeric (10,0), date date So, we are doing…
Anthony
  • 167
  • 2
  • 16
0
votes
1 answer

convert database field encoding in Jet Database / Delphi

I have a legacy application written in Delphi which uses a Jet Database as its back-end for storing data and I need to export the data to a new format. Opening the database with MS Access (Windows) or MDBViewer (Linux), in fields of type "MEMO"…
cmpscabral
  • 183
  • 3
  • 13
0
votes
0 answers

Error opening recordset in VBA

I'm developing an Excel VBA application using ADO. I'm trying to open a recordset, but the open method fails if my table has more than 65536 lines. I know this number is the old Excel line limit, but I'm using the 2016 version and the correct…
gscofano
  • 83
  • 10
0
votes
0 answers

Microsoft Jet database engine could not find the object: special characters in file names

I am creating a DataTable from a csv file and struggling with file names as they contain brackets and '#' characters. The code: CnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Me.TextBox2.Text & "\;Extended…
user2723490
  • 2,010
  • 4
  • 27
  • 37
0
votes
1 answer

Integrate JET Templates to an EMF-GMF plugin

I created an plugin that lets me model JSF Applications. I created it using Emfatic, Ecore, EMF, GMF. So now i have 5 projects in my workspace: myapp myapp.diagram myapp.edit myapp.editor myapp.tests If i run myapp as a Eclipse Application i can…
AdrianS
  • 1,980
  • 7
  • 33
  • 51
0
votes
1 answer

Microsoft Text Driver or Microsoft.Jet.OLEDB.4.0

In my application i have to read data from a CSV file. I want to use Microsoft Text Driver or Microsoft.Jet.OLEDB.4.0. I am confused between the two. Which one should i opt for?
Sidharth
  • 1,251
  • 1
  • 25
  • 40
0
votes
2 answers

How are DateTime and Number formats encoded in Jet4?

I'm writing a low level tool to scan and recover data from damaged Jet4 MDB files. I'm scanning through pages, parsing Rows, and decoding columns. If I have the raw 8 byte value for Datetime fields, how can I convert this to a string representation…
user1316642
  • 71
  • 6
0
votes
3 answers

Polling database for updates from C# application

I'm attempting to create my first "real" C# application - a small pet project to help schedule peer reviews at work. Due to the insane amount of process/bureaucracy involved in implementing anything new - as well as the fact that I'm doing this away…
AgentConundrum
  • 20,288
  • 6
  • 64
  • 99
0
votes
3 answers

very slow record inserts into Jet database using ADO.NET / OleDb

I'm trying to insert a lot of records into a Jet (Access) database via ADO.NET / OleDb. It is running painfully slowly. The slowness is mainly due to the DbDataAdapter.Update method. In Microsoft's words, ...these statements are not performed as a…
Hugh Allen
  • 6,509
  • 1
  • 34
  • 44
0
votes
3 answers

Open ms-access .mdb in 32 and 64bit windows using c#

I use a connectionstring like "Provider=Microsoft.Jet.OLEDB.4.0;..." to open a .mdb database. Moving to a 64bit computer this does not work anymore since there is no 64 bit implementation. My understanding is that it is done this way because Jet is…
hultqvist
  • 17,451
  • 15
  • 64
  • 101
0
votes
0 answers

Send Data Tables to MS Access DB using OleDB

I have two data tables and need to store them into an Local Access Connection. I plan on running queries against both of them. (Microsoft.Jet.OLEDB.4.0). How do I store them into the local Access? Here is my thought process so far, i simply want…
Mmsyther
  • 11
  • 3
0
votes
1 answer

My UPDATE statement with WHERE EXISTS does not limit to the SELECT statement results

I have data in a temporary table and I am checking for duplicates in two other tables. I want to set a flag on the temp table (SET DupFlag = TRUE) for all duplicates found. My SELECT statement works perfectly, returning only the 48 duplicates that…
Ginger
  • 3
  • 2
0
votes
1 answer

Can't connect to dBase files from web app

I have a web app, written about 10 years ago (VB.NET/ASP). It uses the following connection string to connect to dBase 5 files: Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=[SOURCE_PATH]; This has been working great for years. Now we…
Tamila
  • 177
  • 1
  • 3
  • 17
0
votes
0 answers

Single sign on for applications whose front end developed using the java script, html, css technologies

I am using oracle JET library to develop front end applications. I would like to implement SSO for this application. There is one authentication server, there we provide user details, if success, the server redirects the request to my application.…
Sreenivasulu Singana
  • 1
0
votes
1 answer

Excel VBA JET SQL query from another workbook

I Have a file on D:\SampleData.xlsm containing many entries with columns and headers. I need to query just a specific columns from MyData worksheet within this file. When I am using the approach suggested by @Parfait here: Excel manufacturing…
Bartek Malysz
  • 922
  • 5
  • 14
  • 37
1 2 3
…
38 39