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
4
votes
2 answers

Inserting a million small records into Extensible Storage Engine (JetBlue) - quickly

I'm hoping Laurion Burchall reads this :-) I need to insert a million tiny records as quickly as possible. Right now I'm in a very tight loop where, for every record, I a) start a transaction (JetBeginTransaction) b) prepare an update…
stuck
  • 2,264
  • 2
  • 28
  • 62
4
votes
5 answers

Which affects Access Database performance more: Thousands of tables or Millions of records?

We're using an Access Database as the back-end to our software product. The program has been alpha/beta tested at a company for about 2 years now and we've noted that one of our tables has been filled with over a hundred thousand records in that…
RITBeast
  • 43
  • 1
  • 5
4
votes
3 answers

OleDB Jet - Float issues in reading excel data

When I read a sheet into a DataTable using the OleDbDataReader, floating point numbers loose their precision. I tried forcing OleDb to read the excel data as string, but although the data is now contained in a DataRow with each Column defined as…
Patrick
  • 41
  • 2
4
votes
2 answers

C# import CSV file with schema.ini creates table but doesn't load data

I need to import some CSV files into a temporary table inside an MDB database. The files come from a file upload on an ASP.NET Web application. This is my CSV file: "Operating Unit Organization Name";"Year";"Sales Rep Name";"Date";"Week";"Product…
Cheshire Cat
  • 1,941
  • 6
  • 36
  • 69
4
votes
4 answers

Create a table with integer or numeric(4.0) in dBase width Jet.4

I want to create a table (.DBF file) with an Integer(4) field using Microsoft Jet dBase Provider. There is my code : Dim conn As New OleDb.OleDbConnection Dim comm As New OleDb.OleDbCommand conn.ConnectionString =…
user2089789
4
votes
2 answers

Does ACEDAO support row level locking?

There was a problem with DAO 3.6 in that it didn't support row-level locking. For details, see this Knowledge Base article. I learned from the Access team's blog: In Office Access 2007, new objects, properties, and methods will be added to DAO…
onedaywhen
  • 55,269
  • 12
  • 100
  • 138
4
votes
2 answers

"Nullable" property for ADOX table column?

I'm trying to create an Access file (.mdb) with C#. I'm exporting data from SQL for a legacy process. I got it working, the only problem I'm facing is setting columns to nullable. Here's what I have (removed most columns for brevity): private void…
John Straka
  • 1,874
  • 5
  • 28
  • 49
4
votes
6 answers

Reading Comma Delimited Text File to C# DataTable, columns get truncated to 255 characters

We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a temporary .txt file using a schema.ini. (I'm not sure yet exactly why are are writing to this temporary file, but that's how the code currently works). From…
Greg Bailey
  • 79
  • 1
  • 1
  • 8
4
votes
6 answers

How Can I Remove Access Db's temporary ldb file

I have an ASP.NET Project. I am connecting to the DB and then closing and disposing of the connection object. But when anyone enters my site, MS Access creates a temporary dbname.ldb. When I want to download my original mdb file from my server it…
İbrahim Akgün
  • 1,527
  • 11
  • 37
  • 63
3
votes
6 answers

PyODBC and Microsoft Access: Inconsistent results from simple query

I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program. The Microsoft Access database comes from a third-party; I am only reading the data. I have generally been having success in…
Oddthinking
  • 24,359
  • 19
  • 83
  • 121
3
votes
1 answer

SSIS FlatFile Access via Jet

Is there a way to access FlatFiles with the Microsoft.Jet.OLEDB.4.0 driver in SSIS ? The acces via the FlatFile Source is much better, it´s just about if there exists a way to do it with the Jet driver.
kamahl
  • 931
  • 1
  • 8
  • 20
3
votes
0 answers

Intermittent error 3051 using VB6 DAO - "already opened exclusively by another user, or you need permission to view its data"

After our VB6 program worked for many years without problem, some users have began getting intermittent file opening errors. This started three or four years ago (not sure when) only for some users. Our development machine has never had these…
finch
  • 549
  • 1
  • 6
  • 18
3
votes
2 answers

Undefined function 'Replace' in expression

I am having a VB.Net application. I connect it with a MS Access database. Now I have to execute a query. My query is : Update table1 set field1=replace(field1,'|','"') This query seems to work fine from the query analyzer of the Access database but…
Rajdeep
  • 485
  • 4
  • 15
  • 28
3
votes
1 answer

OleDbDataAdapter datatype mismatch using Jet

I'm using an OleDbDataAdapter (Microsoft.ACE.OLEDB.12.0 to be precise) to retrieve data from an Excel workbook. For one table I'm using a typed dataset but for another table I can't do that since the number of columns is unknown (the Excel template…
Koen
  • 3,626
  • 1
  • 34
  • 55
3
votes
6 answers

SQL: How to display records for only 30 days

I tried to use SELECT * from Results WHERE DATEDIFF(d,Date,getdate())<30 But it seem having error with this. For each record submitted will only display 30 days. May I know if my syntax is correct? Greatly Appreciated, Stan
Stanley
1 2 3
…
38 39