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 move (INSERT+DELETE) the last n rows from a table in Jet SQL / Access 2003?

I have a system that receives input from the public each day. Each morning when it starts up I want to run a VB script that moves every input beyond the latest 500 entries into a backup table. This is kind of a complete archive of the systems…
Jotham
  • 1,122
  • 1
  • 10
  • 23
0
votes
1 answer

ASP error Microsoft JET Database Engine error '80040e07'

I am working on designing a asp form which will query an Access database (mdb). The outcome of the form is to query data results between a date range (date from and date to), and output the results on the asp page below. When I try and run the query…
JaysFan 1977
  • 37
  • 1
  • 6
0
votes
1 answer

Unable to query dynamically named range on Excel sheet using ADO

Suppose I have an Excel Sheet named Adjustments stored in a variable called wksName and, on that sheet, I have a named range defined as follows if you look in the Name Manager: tblData =OFFSET(Adjustments!$A$1,0,0,COUNTA(Adjustments!$A:$A),4) So…
John Bustos
  • 19,036
  • 17
  • 89
  • 151
0
votes
0 answers

Jet showplan.out shows double output for one query

I have a recordset in a VB6 project that get's populated from MS Access. To understand the mechanics of the JET SQL Engine I turned the SHOWPLAN to ON. What I see in the showplan.out output file is --temp query-- - Inputs to Query - [some…
CodingEdge
  • 143
  • 1
  • 10
0
votes
0 answers

Performance unstable for VB6 app using ADO to MSAccess

Currently the VB6 application is using a local .mdb that stores the queries and has linked tables to 2 other networked .mdb files. I'm not sure how the Jet engine can perform with this kind of setup. I've noticed a considerable delay when the number…
CodingEdge
  • 143
  • 1
  • 10
0
votes
1 answer

Error Running Crosstab Queries in Excel

I have an issue running an SQL query on an excel spreadsheet which I'm looking for some help on: I'm using Excel and Access 2007 on a windows xp machine sp3. I recently found this post which showed me how to run an Access crosstab query on a…
Eddie
  • 611
  • 3
  • 13
  • 23
0
votes
1 answer

Updating old app that uses DAO 3.5 and jet 3.5

So I was asked a while ago at work by my boss what it would take to update from installshield 7.0 to something else and one of the things that is holding us back is a legacy app that depends on installshield installing dao 3.5, jet 3.5, mdac and…
Neal Cynkus
  • 64
  • 9
0
votes
0 answers

ASP.Net OLEDB Jet across multiple computers

I am using Jet OLEDB (Microsoft.ACE.OLEDB.12.0) on my ASP(C#) IIS7 website to connect to an Excel spreadsheet on the same computer/server as my website. Everything works fine except that the connection string does not like a UNC Path. It will work…
user3050420
  • 1
0
votes
2 answers

Delphi 2009 ADO database access in cmShareDenyWrite mode

I have a Delphi 2009 application that is attempting to open an ADO connection (dbGo) to a Microsoft Access .MDB file in cmShareDenyWrite mode, using the Jet 4.0 OLE DB provider. The goal is to open the .MDB file in read/write mode, but to prevent…
Johnula
  • 54
  • 3
0
votes
0 answers

DTS .xls import;

I'm new to DTS and wwas wondering if there was anyone who have had some experience with SQL on a server. I'm having an issue with the SQL Server Import and Export Wizard. I've messed with the syntax and I've messed with it and I keep getting the…
user2937830
  • 1
  • 1
0
votes
0 answers

Create one query with sum and count with each value pulled from a different table

I am trying to create a query that pulls two different aggregated values from three different tables during a specific date range. I am working in Access 2003. I have: tblPO which has the high level purchase order description (company name, shop…
Scott
  • 1
0
votes
1 answer

connecting a visual basic 2008 express program to microsoft access 2003 in 64 bit operating system

I am working on an experimental project and have run into a problem trying to connect a microsoft access database to my program in visual basic 2008 express and keep getting the following message when I try to make the connection. "The…
Lewis Carter
  • 3
  • 1
  • 5
0
votes
1 answer

To which C# data type does MS Access "Number" type correspond?

According to http://msdn.microsoft.com/en-us/library/office/aa211091(v=office.11).aspx, the MS Jet database engine has no "NUMBER" data type; yet that is what I see in the MS Access design view of the table that I'm querying - that the data type of…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

How do I display all records in a subform EXCEPT the one being displayed in the main form in Access 2010 without VBA?

I'm working on a database in Access 2010 which stores addresses. I've carefully designed the tables so that I can store a person and an address separately and then relate them through two other tables (relationship between the people is necessary to…
4AM
  • 199
  • 1
  • 11
0
votes
1 answer

access query with multiple where clauses

I am trying to run a query in access which carries out a two stage currency conversion. It takes an exchange rate from a Exchange Rates Table in the transactional Currency and then takes the Exchange rate of the Region. Is there any way to do this…
Dave Ward
  • 97
  • 1
  • 3
  • 12
1 2 3
…
38 39