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

Only Row 1 of Sheet 1 is returned by JET 4 even when using the access import wizard

I have used a variety of methods to try and import this data (a 97-2000 xls file generated by a crystal report server each morning that fills the first sheet fully and more than half fills the second sheet - about 120,000 records in total although…
Makita
  • 726
  • 5
  • 12
0
votes
1 answer

SSIS - Use file name parameter in SQL Lookup Command (JET OLEDB)

Can I parameterise the SqlCommand in a Lookup Transformation when using the Jet engine against a CSV file? Is there another way to work with CSV's and Lookups? I have a JET OLEDB connection that uses an expression to get the folder location from a…
PeterX
  • 2,713
  • 3
  • 32
  • 42
0
votes
0 answers

VB6+Access(ADO/JET) Randomly getting "Disk or Network Error" or "Cannot find the input table or query X on Database Y"

We have a Practice Management system that is about 15 years old. I've been working on it for about 12, and I've never encountered this problem until just recently, and we can't figure it out. It is written in VB6 which uses ADO/JET to access an…
SeiferTim
  • 438
  • 4
  • 18
0
votes
3 answers

How do I solve syntax error in from clause?

string query = "select a.Name,a.Add from GroupDetails a join General b on a.ID=b.Id where b.AccCode='" + label1.text + "'"; OleDbCommand cmd = new OleDbCommand(query, con); OleDbDataAdapter daName = new OleDbDataAdapter(cmd); OleDbDataReader dr =…
Animesh Ghosh
  • 331
  • 8
  • 16
  • 28
0
votes
0 answers

Importing from Excel / Excel Linked Server shows no data

This is a common problem I've had for years and I'm sure many others have experienced. Every time I search, I don't seem to get exactly what I'm needing, so I figure I'd just ask to see if anyone has an answer or at least point me to the place with…
rhansen0912
  • 11
  • 1
0
votes
1 answer

ReplaceMent for Jet Excel Database Connection?

I have quite an old code that should run on modern machines. The purpose of that code is to read Excel Files and do some fancy stuff with it. The Connection-string to the Excel-file is the following: private static readonly string…
Ole Albers
  • 8,715
  • 10
  • 73
  • 166
0
votes
1 answer

How to get AccessVersion from C#

How do I go about getting the AccessVersion? I'm seeing references to objects with a 'properties' collection, but I have no idea what the object is. For example http://support.microsoft.com/kb/321329 Related to the above, I guess my question is: Is…
Fred
  • 3,786
  • 7
  • 41
  • 52
0
votes
1 answer

.NET 4.0 Reading and writing from and to and MDB file (2010)

I was tasked with creating a simple API to access an MDB containing regional data (Region Name, Region ID, Country, etc). I have read about the Jet Engine but there is not a lot of good tutorials or documentation on it. I would like to build this…
Alexander Ventura
  • 1,150
  • 1
  • 10
  • 32
0
votes
0 answers

How to automate Jet/ACE compaction? (Access DB)

I think the title sums it up fairly well. I'll be working with a range of versions from the old 2003 all the way up to the most current releases. It's a hosting company that has a lot of clients with access DB's. What we're looking to do is to…
Fred
  • 3,786
  • 7
  • 41
  • 52
0
votes
1 answer

Using Microsoft OLEDB JET driver to read Excel CSV file, how to keep the double quote in input file?

I'm using the Microsoft OLEDB JET driver to read Excel CSV files (comma delimited) "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxx; Extended Properties='text;HDR=Yes;IMEX=0'" I use code like below to load the input file into a datatable, this…
user2494400
  • 1
  • 2
0
votes
1 answer

Trouble outputting a recordset value with fieldname a reserved word in VBA

In vba, I've created a recordset called 'rs' that includes a field named "EmployeeName" and another named "Position". If I execute ThisWorkbook.Worksheets("Contact").Cells(row, 1) = rs("EmployeeName") it works fine, but if I instead do…
Ben
  • 20,038
  • 30
  • 112
  • 189
0
votes
1 answer

Copying text from .txt file in Excel using ADO ignores first row

I have used some code to import a text file into Excel using ADO as shown below: Sub ImportTextFile() 'Imports text file into Excel workbook using ADO. 'If the number of records exceeds 65536 then it splits it over more than one sheet. …
CluelessVoid
  • 3
  • 1
  • 2
0
votes
0 answers

How to implement a variable in Jet SQL INSERT INTO clause

Is there a method in MS Access Jet SQL to implement a substitution variable so that the executor can input their own new Table name? See SQL below: SELECT Subset.FacNo, Subset.BldgNum, Subset.Qrate AS Qrate, Subset.MaxOfSqFt AS SqFeet,…
Stacy
  • 63
  • 8
0
votes
1 answer

MS Access/JET "Join Expression Not Supported" Any Way to Fix This Query?

MY CODE (Im using MS Access 2000 with JET Database engine) SELECT Members.First_Name + ' ' + Members.Last_Name AS Member, iif(NULL,Friends.My_E_Mail, Friends.Friend_E_Mail) AS E_Mail, Members.First_Name AS Name FROM ((Members …
James Putin
  • 13
  • 5
0
votes
1 answer

"Union Operation not allowed in sub query" is there a way to fix this in one single query?

This Query Dose NOT work in Access 2000 SELECT (Members.First_Name + " " + Members.Last_Name)AS Member, (SELECT Friend_E_Mail, FROM Friends,Members WHERE My_E_Mail = ? and Friend_E_Mail <> ? UNION ALL SELECT My_E_Mail,FROM Friends,Members WHERE…
James Putin
  • 13
  • 5
1 2 3
…
38 39