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

Getting first 3 chars from "Job No." to use as filter - Jet Reports

I am struggling to get the Quantities from the Job Ledger Entries Table which I need to filter on the first 3 letters of the Job No. pulled from the Item Budget Entries.. I am new to Jet Reports and using Express.. I have tried the function: Should…
Dan Tromp
  • 189
  • 12
0
votes
1 answer

JET/ACE opening workbook in other version of Excel

I have Office 2010 (32-bit) and Office 2013 (64-bit) installed on one system. They were both operating fine separately. Then the other day Office 2013 says there are some updates to install, I agreed and let it install the updates. Now when I…
Christopher Thomas Nicodemus
  • 407
  • 4
  • 9
0
votes
3 answers

Error in get data from Excel

I'm trying to get data from Excel file using: OpenFileDialog OpenCSVDialog = new OpenFileDialog(); OpenCSVDialog.Filter = "Excel |*.xlsx"; OpenCSVDialog.ShowDialog(); ExcelFileName =…
Tom
  • 1,343
  • 1
  • 18
  • 37
0
votes
0 answers

I want delete a duplicate lines

I have a big file (7 milion rows) where some of rows are repeated, I want delete a duplicate lines . For this reason, I used from: sort {file-name} | uniq -u> data.txt But I saw again in the new file, repeated data: for example: 14693 10167…
Y.Mohammadi
  • 1
  • 1
0
votes
0 answers

Correct connection string for delimited text file on 64-bit excel

I have a VBA sub that pulls data from multiple text files and I am currently working on importing this workbook from 32-bit excel to 64-bit excel. My current connection string (which works on 32-bit excel) is as…
John Bustos
  • 19,036
  • 17
  • 89
  • 151
0
votes
1 answer

Jet Essentials not running with Excel - Possible ODBC SQL Native Client issue

I'm using jet essentials on office 365 excel and the sql db is linked with a crm nav 2013. The problem is strictly with a single workstation because other workstations are able to connect to the server to generate reports. I am getting the following…
No Body
  • 287
  • 2
  • 4
  • 12
0
votes
2 answers

OLEDB JET error in Vista & Windows 7, not in XP

I wrote an application with VS2008 on Windows XP, and produced an .EXE file. This application will only run on Windows XP OS. It fails on Vista and Windows 7. It gives an error saying that a Microsoft OLEDB JET 4.0 occurred. I use Microsoft Access…
SamanehHasani
  • 3
  • 1
  • 3
0
votes
1 answer

Cannot read Database or object read only

I am trying to query an Excel file from another file using VBA and ADO options. When I run this code it's throwing the error "Cannot updata, Database or object Read only": Public Function fnExecuteXlQuery _ (ByVal strPath As String, _ ByVal…
Anarach
  • 440
  • 2
  • 16
  • 35
0
votes
1 answer

Error: "Join expression not supported"

I'm attempting to query a few named ranges in an Excel workbook using a JET Connection and am receiving an error (Run-time error '-2147217900 (80040e14)': Join expression not supported) when I attempt to add a second condition the one of the…
ignorantcity
  • 31
  • 6
0
votes
3 answers

DoCmd.OpenReport Asks for values Access07

I have a form that opens a report based on a combo box selection. Which looks like. The invoice shipment button opens the report via DoCmd.OpenReport "ItemList4", acViewReport, , "ShipRef = " & Me.SRCB SRCB is the combo box next to the shipment…
Rynoc
  • 45
  • 1
  • 1
  • 9
0
votes
2 answers

Retrieve "Variant" data type from Enterprise Architect using DXL

How can I use the DXL OLE mechanism to fetch a diagram's modification time from Enterprise Architect 12? Details: I want to retrieve diagrams from EA and integrate them as OLE object into IBM Rational DOORS 9.5. This is already working. I intend to…
Twonky
  • 796
  • 13
  • 31
0
votes
1 answer

Auto-Answer UpdateQuery dialog Access07

I have an update query that is run via VBA everytime a form loads. Whenever the query is run it asks you if you want to update the records. Is there a way to automatically answer yes? I forgot to mention that this is achieved via DoCmd.RunSQL with a…
Rynoc
  • 45
  • 1
  • 1
  • 9
0
votes
1 answer

How to read data from embedded database?

I wanna improve one application which database is unknown for me. So i have interface to work with but no data to fill forms/documents etc in a new application... Installation folder only containts .dll files without any clue of database. For now i…
KuKeC
  • 4,392
  • 5
  • 31
  • 60
0
votes
4 answers

Getting around the lack of a Left Trim(string, char[]) function in JET / Access

I need to remove leading zeros from a string field in an Access database that is destroyed and recreated every time it is used within a C# program. Most string libraries (even SQL ones) include a Trim function to remove leading or following…
DonaldRay
  • 503
  • 3
  • 11
0
votes
1 answer

How to SELECT [header text w. dot] AS xxx FROM an Excel table?

Summary: Using the Jet.OLEDB provider and the SQL query, I do not know how to access the column the header text of which contains a dot. Is there any way to escape the dot in the SELECT query? Details: I am using a connection…
pepr
  • 20,112
  • 15
  • 76
  • 139
1 2 3
…
38 39