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

System.Data.OleDb.OleDbException: Invalid internet address. How do you connect to excel files located on a webserver using OleDb

I'm trying to create an OleDb connection to an Excel file that is located on a SharePoint server. The example code I'm playing with at the moment throws an OleDb exception "Invalid internet address": public static void ConnectToRemoteExcelFile() …
Edward Wilde
  • 25,967
  • 8
  • 55
  • 64
5
votes
2 answers

Is RavenDB just a frontend for Access?

I've started using Raven for my last project. When my boss learned about it, he mentioned it's based on Access and he had very bad experience with multiple users and Access. Now I have to either switch or prove to him he is wrong.
Lincoln
  • 749
  • 1
  • 7
  • 13
5
votes
2 answers

Why is this very simple SQL query failing in MS Access?

I have a query that by all rights should not possibly fail, and I can't for the life of me figure out why INSERT INTO Grocery_Store_Prices(Store,Item,Brand,Price,Unit,Quantity,Note) VALUES("Kroger","Cheesy Poof","Cartman",0.51,"fart",15,"what is…
BobMcGee
  • 19,824
  • 10
  • 45
  • 57
5
votes
5 answers

Where can I find the documentation for the particular kind of SQL used by the Jet 4.0 engine?

Which I think is the same as the one used by MS Access, which I think is not the same as the one used by MySQL and others. I need the documentation for this particular "kind" or "subset" of SQL language.
Juan
  • 15,274
  • 23
  • 105
  • 187
5
votes
2 answers

Accessing another password protected database in an SQL query in Access 97

I am currently working on an SQL query for Access 97. Given are the following tables (simplified for demonstration purposes), each of which are located in separate mdb files: Table1 in C:\db\db1.mdb: PartyId (PK) Name ------------ -------- …
Aurora
  • 1,334
  • 8
  • 21
5
votes
6 answers

Is Jet database engine included in Windows xp, vista and Windows7?

I need a data store for single-user, read-only access. I need multiple tables, but not related. I also need to do two-column indexing. Seems like Jet is a good choice. Front end will be either VB or C#. The data is not user-entered data, but meta…
bill seacham
  • 395
  • 1
  • 2
  • 4
5
votes
5 answers

How do I create a Microsoft Jet (Access) database without an interop assembly?

I need to create an access (mdb) database without using the ADOX interop assembly. How can this be done?
Sam Saffron
  • 128,308
  • 78
  • 326
  • 506
5
votes
2 answers

Open a Standard Jet DB 4.0 file (*.vmd)

I downloaded a database file with the extension "VMD". Now I'm looking for a windows software which can open this file, so that i can see all the included tables to (later) export some of them info csv. When I open the downloaded file with a normal…
Tony Montana
  • 123
  • 1
  • 2
  • 9
5
votes
5 answers

Microsoft JET SQL Query Logging or "How do I debug my customer's program?"

The problem: We use a program written by our biggest customer to receive orders, book tranports and do other order-related stuff. We have no other chance but to use the program and the customer is very unsupportive when it comes to problems with…
VVS
  • 19,405
  • 5
  • 46
  • 65
5
votes
3 answers

Configure ASP.NET to use x86 on x64 Windows

I am trying to deploy GAL Modifier, which is an ASP.NET website which uses Microsoft Access on a Windows 2003 x64 machine. However there is no JET driver on x64 (see here), so the change is to use change the target CPU to x86. However as it is a…
Robert MacLean
  • 38,975
  • 25
  • 98
  • 152
4
votes
3 answers

MS Access slow in network share

I have a .NET application (VB.NET) that runs against a MS Access database. Every data request connects to the access database, runs and returns the query and closes the connection back again. I placed the database on a windows xp 32-bit machine. I…
Roel Geusens
  • 147
  • 1
  • 10
4
votes
1 answer

ADO.NET way for creating a linked table

I'm writing an application that uses ADO.NET OLEDB provider. Database is Access. Most of DB interaction is through DDL/DML SQL queries. I now need to create linked tables and there doesn't seem to be a way of doing that with ADO.NET alone. Neither…
sameerz
  • 61
  • 1
  • 3
4
votes
2 answers

SELECT @@IDENTITY not scoped by DB object?

I have the following code in MS Access: Sub IdentityFail() Dim db1 As DAO.Database, db2 As DAO.Database Dim id1 As Long, id2 As Long CurrentDb.Execute "CREATE TABLE LocalDummy (Col1 AUTOINCREMENT, Col2 INT)", dbFailOnError Set db1 =…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
4
votes
1 answer

Network problem, suggestions sought

The LAN which has about a half dozen windows xp professional pcs and one windows 7 professional pc. A jet/access '97 database file is acting as the database. The method of acccess is via dao (DAO350.dll) and the front end app is written in…
kjack
  • 2,004
  • 3
  • 26
  • 41
4
votes
2 answers

What's the difference between Jet OLEDB:Transaction Commit Mode and Jet OLEDB:User Commit Sync?

Althoug both Jet/OLE DB parameters are relativly well documented I fail to understand the difference between these two connection parameters: The first one: Jet OLEDB:Transaction Commit Mode (DBPROP_JETOLEDB_TXNCOMMITMODE) Indicates whether Jet…
Daniel Rikowski
  • 71,375
  • 57
  • 251
  • 329
1 2
3
…
38 39