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

What happens if you try to update a locked record in JET?

If I use JET/DAO to open a recordset on a MDB database using dbPessimistic locking, what will happen if another user tries to update a row in that recordset at that time? Will there be an error, or will JET/DAO keep trying until the row is…
CJ7
  • 22,579
  • 65
  • 193
  • 321
0
votes
2 answers

Read Permission problem on .NET Embedded Resource - Access DB file & SSIS

I am currently creating dynamic SSIS packages that import/export and access data between a SQL Server and several Access DB files. (Jet files if you want to get technical.) Anyways, everything is successful during testing, as long as my SSIS…
D3vtr0n
  • 2,774
  • 3
  • 33
  • 53
0
votes
1 answer

How do I query tables from a Big5 Jet Database on Windows 7 en-US from C#?

I've got a really old Big5 Jet Database that I would like to convert to Unicode and SQLite. The first step here is to actually open the jet database. Using the C# ADO, and I can enumerate the tables in the Jet DB. They are all garbled, which is…
RLiao
  • 1
0
votes
1 answer

Asp Access db: Microsoft JET Database Engine error '80004005' Unspecified error

Server is dedicated and I have remote access. We have custom ASP CMS with Access database and we use custom error pages for "mod rewrite". It works great. This website is available in 6 different languages and each language has its own domain and…
Vedran Vuleta
  • 1
  • 1
  • 2
0
votes
4 answers

SQL Statement will not execute in C#?

Hey Guys, here is my code for this, the only help i get from VS is that the INSERT INTO statement syntax is incorrect? I have gone through all of the code and just cannot see where i have gone wrong, can someone gimme a hand please? public…
Ash
  • 8,583
  • 10
  • 39
  • 52
0
votes
1 answer

Querying text file with SQL converts large numbers to NULL

I am importing data from a text file and have hit a snag. I have a numeric field which occasionally has very large values (10 billion+) and some of these values which are being converted to NULLs. Upon further testing I have isolated the problem as…
Niall
  • 1,551
  • 4
  • 23
  • 40
0
votes
2 answers

ASP/ASP.net: Web-based JET database management tool?

I need to manipulate some tables in a JET database housed on a web-server: check existing indexes change table cluster/primary key see what tables exist rename tables add tables drop tables browse data etc I don't have the option of installing…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
0
votes
1 answer

Does Microsoft Jet 4.0 support 64bit integers?

I have a csv file that I'm trying to import into a Sybase SQL Anywhere database using the SABulkCopy (Sybase's version of SQLBulkCopy) class in C# .NET. The csv file's first column maps to a 64bit integer primary key value in the Sybase DB. There is…
user1197862
  • 37
  • 2
  • 7
0
votes
1 answer

MS Jet Oledb What Type Of Source Is ComSys?

I am trying to understand using of variety of databases for research, recently I've been studying Jet OLEDB. In some source code I saw this: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=ComSys; What is this ComSys? Is it a path To somewhere? If…
Synxmax
  • 2,226
  • 1
  • 22
  • 38
0
votes
2 answers

sql select statement against a csv file, using JET.OLEDB driver

I'm trying to execute the following SQL statement (built and tested in SQL Server 2005) Select * From mytesttable where myPk in ( select t3 from ( select field1, substring(field3, charindex(":", field3),6) t2, min(mypk) t3 …
dot
  • 14,928
  • 41
  • 110
  • 218
0
votes
1 answer

VBScript error with JET Database Engine request

I am trying to retrieve some info from a csv file by doing a request to it but I keep having this error: No value given for one or more required parameters, Code 80040E10 Source: Microsoft JET Database Engine It concerns the following line of my…
Wawa41
  • 51
  • 1
  • 1
  • 7
0
votes
1 answer

How to parse JET/ACE SQL

I want to emphasize that I am looking for the "right" way to do something like this in general and for Access in particular. What I have below is the solution I came up with for use on a SQL Server, but if it's not right, or if it won't work on…
Patrick McGuire
  • 1
  • 2
-1
votes
1 answer

ADO Insert and Delete executing on 2 different connections causes errors

The problem: I'm seeing a combination of E_FAIL and database corruption on each of two threads that each have their own connection open to a jet 4.0 mdb. Scenario: I have an application where: Thread 1 is the main thread. It has an ADO Connection…
Lynn Crumbling
  • 12,985
  • 8
  • 57
  • 95
-1
votes
1 answer

access MDB update data in C# via sql

I've had help here Inserting and Updating data to MDB but still have a problem with update I have an access mdb file with table "Table1" and 3 colums ID INFO TEXT I can add new info, find info but the update gives me an unknown error. Something…
Iakovl
  • 1,013
  • 2
  • 13
  • 20
-1
votes
0 answers

jet module not found in npm registry

npm install --save-dev @types/jet D:\AdMob> npm ERR! code E404 npm ERR! 404 Not Found - GET https://registry.npmjs.org/@types%2fjet - Not found npm ERR! 404 npm ERR! 404 '@types/jet@*' is not in this registry. npm ERR! 404 npm ERR! 404 Note that…
Vutukuri Manikanta
  • 1
1 2 3
…
38 39