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

Formatting results using SQL select with JET

I have data in Excel files that I am pulling out using the MS JET OLEDB provider. The results of my select are being passed into a component that I cannot change to generate an HTML table on the fly. Some of my data files contain numbers that I…
NJChim
  • 287
  • 1
  • 2
  • 7
0
votes
1 answer

using InStrRev() and similar functions in Jet/ACE queries outside of Access

Hia, I'm struggling a bit while forming some SQL queries. Currently I'm using: InStrRev(TABLE.[_URL],"/")+1) AS OUTPUT Given an input of a URL - I want to extract the last part eg: www.url.com/some/text/here Should return here There are always 3…
sbozzie
  • 717
  • 2
  • 12
  • 33
0
votes
2 answers

How does JET OLEDB Parameters compare strings with text field in and Access DB

I have the following update query in C# using a JET OLEDB connection, connecting to a ms access DB file. The query fails to change the fields, it runs correctly but just 0 rows changed. I think the problem is how parameters are processed and…
Muad'dib
  • 423
  • 5
  • 14
0
votes
2 answers

checking an access file via java and mailing for a specific row

I need to write a program that checks a access .mdb file and when a specific row is added (say the "name" field column of the newly added a row that contains a specific string, it should send an email to a specific address. For this I am planning to…
Hellnar
  • 62,315
  • 79
  • 204
  • 279
0
votes
1 answer

CurrentDB.Execute Active Record Reference

Access 2010 here. There are two tables in a 1-to-1 relationship (MainDB, Parts) and a command from the form (MainForm) that operates on the "Parts" table: CurrentDb.Execute "DELETE * FROM Parts WHERE ID = ID", dbFailOnError PartsForm.Requery This…
Phizon
  • 93
  • 4
  • 14
0
votes
1 answer

Inactivity causes data loss in VB6 Jet.OLEDB.4.0

I have a VB6 application that uses a mdb file with Jet.OLEDB.4.0. The application does a good job of saving and retrieving data unless I let it set idle with an open recordset for half an hour or so. If I let the application set idle for awhile and…
user1988364
  • 1
0
votes
2 answers

OleDB connection to excel file fails ONLY in production

I have a VB application using .NET 3.5 that allows users to upload an Excel file. The application then reads from this file and inserts its contents into a database. The problem is that the read seems to fail in our PRODUCTION environment only.…
Zach Esposito
  • 707
  • 9
  • 17
0
votes
1 answer

How can I manually define column types in OLEDB/JET DataTable?

I am importing data from an Excel spreadsheet to a VB.NET DataTable. This Excel spreadsheet has a lot of garbage data in the first 18 rows, including a lot of empty cells. I ultimately remove these rows in post-processing, but I need to access the…
user1077685
0
votes
2 answers

Equivalent of Excel’s NETWORKDAYS function with Jet ADO

Excel's NETWORKDAYS function returns the net working days between two dates. Is there a way of replicating this when connecting to a Jet database via ADO?
Lunatik
  • 3,838
  • 6
  • 37
  • 52
0
votes
1 answer

Reading Excel numbered range with oleDb

I am trying to select everything in the B - E columns from row 4 onwards, where row 4 are the headers. My sheet name is " PRODUCTION_Insurer Index". My research so far has hinted that because my sheet name has spaces in it, I need to wrap it in…
Adam Lonsdale
  • 37
  • 7
0
votes
1 answer

Defining an SQL query from various input textboxes

I wanted to know what would be considered "best practice" in terms of defining an SQL query based on input from various textboxes on a web page. Per say, lets say if you have 8 input textboxes on a website, would you be needing to use a bunch of if…
Jason Kelly
  • 2,539
  • 10
  • 43
  • 80
0
votes
1 answer

Microsoft Jet database engine could not find the object for xls but the same sheet as xlsx works fine

I have a sheet name "Test (testing)". I can access this sheet just fine when I use a xlsx workbook but when the workbook is in the xls format I get the following error: System.Data.OleDb.OleDbException (0x80040E37): The Microsoft Jet database engine…
Justin808
  • 20,859
  • 46
  • 160
  • 265
0
votes
4 answers

Reading pivot table with c#

I am trying to read an excel-sheet containing a pivot table generated by macros with the following connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path; Extended Properties="Excel 8.0;HDR=NO;"; the problem is that the values…
Nader Sghir
  • 81
  • 1
  • 8
0
votes
1 answer

Connect to an access database in a remote directory using dao (VB6)

I need to replace this structure: dim base as dao.database set base = opendatabase ("c:\path\name.mdb") with another in which the .mdb is located in a server directory. I tried: dim base as dao.database set base = opendatabase…
Nitsuga
0
votes
1 answer

Importing from CSV file, how to skip first X rows

I am writing an application to process and upload a csv file to a remote server. The application needs to be fairly flexible, allowing custom mappings of columns. The first big hurdle I've come to is with reading the file, many of the files have the…
bendataclear
  • 3,802
  • 3
  • 32
  • 51
1 2 3
…
38 39