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
9
votes
5 answers

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

I am having a problem with my application. When it is run, the error displays The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. I tried changing Platform to X86 CPU but it could not be changed, the only available…
Furqan Sehgal
  • 4,917
  • 33
  • 108
  • 167
9
votes
6 answers

How to get id of newly inserted record using Excel VBA?

Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this regard however). I currently insert my new record then…
Lunatik
  • 3,838
  • 6
  • 37
  • 52
9
votes
3 answers

How to convert a JET database to SQLite?

I'm a Linux user so an open-source, Linux-friendly solution would be preferable.
Honza Pokorny
  • 3,205
  • 5
  • 37
  • 43
9
votes
1 answer

Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed

I have created an Excel Macro in which I have used Microsoft.Jet.OLEDB.4.0 to fire query on Excel work sheets. It's working perfect on my machine but my client is facing issue with it. (see the attached screen print) Here are details for my…
TechGeek
  • 2,172
  • 15
  • 42
  • 69
9
votes
3 answers

Disable/Flush OleDbConnection Cache

I've been fighting with OleDbConnection for a while now trying to get it to not cache. Basically I am accessing a shared Access database, which is being written to from another application, and then I'm reading back values (having checked that it is…
Rudi Visser
  • 21,350
  • 5
  • 71
  • 97
8
votes
4 answers

Jet Engine - 255 character truncation

I'm needing to import an Excel spreadsheet into my program and have the following code: string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;IMEX=1;HDR=NO;""",…
Graeme
  • 1,657
  • 5
  • 28
  • 46
7
votes
4 answers

I need a workaround for Excel Guessing Data Types problem

I'm creating a utility to import data from Excel to Oracle database, I have a fixed template for the excel file, Now, when I'm trying to import the data by Jet provider and ADO.Net - Ole connection tools, I found the following problem: there're some…
Homam
  • 23,263
  • 32
  • 111
  • 187
7
votes
3 answers

Reset autonumber seed

I have a VB6/Access application that occasionally encounters a problem with wrong autonumber field seed. Lets say there is a table MYTABLE with an autonumber field ID (that is also the primary key). Lets say at the moment the maximum value of ID is…
Incidently
  • 4,249
  • 3
  • 23
  • 30
7
votes
1 answer

The Microsoft ACE driver changes the floating point precision in the rest of my program

I am having a problem where it seems that the results of some calculations change after having used the Microsoft ACE driver to open an Excel spreadsheet. The code below reproduces the problem. The first two calls to DoCalculation yield the same…
Jakob Christensen
  • 14,826
  • 2
  • 51
  • 81
7
votes
10 answers

VBA: Querying Access with Excel. Why so slow?

I found this code online to query Access and input the data into excel (2003), but it is much slower than it should be: Sub DataPull(SQLQuery, CellPaste) Dim Con As New ADODB.Connection Dim RST As New ADODB.Recordset Dim DBlocation As String, DBName…
Dan
  • 9,935
  • 15
  • 56
  • 66
6
votes
2 answers

Multiple LEFT JOIN in Access

I have the following query, which works for MySQL: DELETE `test1`, `test2`, `test3`, `test4` FROM `test1` LEFT JOIN `test2` ON test2.qid = test1.id LEFT JOIN test3 ON test3.tid = test2.id LEFT JOIN test4.qid = test1.id WHERE test1.id = {0} But it…
grjj3
  • 383
  • 2
  • 5
  • 15
6
votes
5 answers

Connect to MS Access remote .mdb file from php on linux

I have been digging internet for couple days, reading very old information, that leads to very old and nonexisting sites, still, I understood, what is needed to achieve my goal. We have a file.mdb on server running WindowsXP, so I need to add it to…
Deele
  • 3,728
  • 2
  • 33
  • 51
6
votes
3 answers

Why is my Access database not up-to-date when I read it from another process?

In my application I do the follwing things: Open a Access database (.mdb) using Jet/ADO and VB6 Clear and re-fill a table with new data Close the database Start another process which does something with the new data. The problem is that sometimes…
Daniel Rikowski
  • 71,375
  • 57
  • 251
  • 329
6
votes
1 answer

SQL sub query with left join syntax error

I have a query I am attempting to run however I keep getting a syntax error when running it. Below is the query that is giving me the error: SELECT A.*, B.Total AS Assigned FROM ( SELECT tblSkillSets.employeeName AS Employee,…
stackSponge
  • 79
  • 1
  • 8
6
votes
3 answers

Problem with using OleDbDataAdapter to fetch data from a Excel sheet

First, I want to say that I'm out on deep water here, since I'm just doing some changes to code that is written by someone else in the company, using OleDbDataAdapter to "talk" to Excel and I'm not familiar with that. There is one bug there I just…
Øyvind Bråthen
  • 59,338
  • 27
  • 124
  • 151
1
2
3
…
38 39