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

MS Access - display repeating rows once with the highest value

I have 2 tables in MS Access with the following values Customer id | name 1 | jon 2 | bob 3 | jack Order id | amount | date | customer 5 | 50 | 3/10/2017 | 1 4 | 100 | 3/10/2017 | 1 3 | 45 | 2/28/2017 | 2 2 | 10 …
Bbob
  • 1
0
votes
1 answer

Multiply non-modifier scores by modifier score - Access SQL

I have a table in MS Access which lists KPI (performance) scores for each person USERID KPI SCORE MODIFIER 20511 Productivity 50 False 20511 Cash per Hour 30 False 20511 Quality 0.9 True 21320 Productivity …
Leroy
  • 634
  • 1
  • 8
  • 33
0
votes
1 answer

.NET app won't run on Windows 2008. Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I have a .NET app written VB.NET version 3.5 on a 32 bit machine. It manually creates a schema.ini file and uses the following code to connect to a .csv file. varConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ …
Atari2600
  • 2,643
  • 2
  • 20
  • 18
0
votes
2 answers

Tool(s) for Converting Ms Access DB to Firebird Embedded

I have Ms Access 2002 database that I need to convert to Firebird 2.5 embedded. What tool(s) that I can use to achieve this? Preferably freeware ones. Thanks!
AFF
  • 43
  • 1
  • 3
0
votes
2 answers

Can these queries be combined into one?

I have this MFC code to extract a list of names from a Microsoft Access Database: // Extracts all the brothers from the specified tables into the passed in array void CPTSDatabase::BuildBrothersArray(CStringArray &rAryStrBrothers) { CWaitCursor …
Andrew Truckle
  • 17,769
  • 16
  • 66
  • 164
0
votes
0 answers

"Operation must use an updateable query" from compiled app but not while debugging

"Operation must use an updateable query". I have an old application with an Access database (Access 2003), but the front end is written in C#.NET (4.5). The database is over 10 years old, and the C# front-end has worked fine for around 7 years. I…
Randy Rowell
  • 37
  • 1
  • 1
  • 5
0
votes
1 answer

Trying to connect to an access with a UDL file

I'm trying to connect to an Access database via a UDL file. I'm wanting to generate a connection string so that I can connect to an access database via ADO.NET. It's been a few years since I've tried to do this. I have Visual Studio 2015 Pro and…
Eric
  • 2,861
  • 6
  • 28
  • 59
0
votes
2 answers

'Syntax error in FROM clause' or 'Syntax error in JOIN operation' when joining two CSV files

I have two CSV files with baseball stats that I'm trying to join as follows, SELECT Master.playerID, Batting.RBI FROM ([Master.csv] INNER JOIN [Batting.csv]) ON (Master.playerID=Batting.playerID) I've written a C# function to…
insomniac
  • 192
  • 1
  • 3
  • 16
0
votes
1 answer

microsoft.jet.oledb.4.0' provider is not registered on the local machine 64 bit

I am getting error while connect to data with oledb provider in my Project. connectionString = @"Provider=Microsoft.jet.OLEDB.4.0;Data Source=" +"filepath.mdb"; OleDbConnection conn = new OleDbConnection(connectionString); try …
Gokul Kumar
  • 389
  • 6
  • 16
0
votes
1 answer

cannot start your application.The work group information file is missing or opened exclusively by another user

From OLE DB provider connection string have Username and Password. I am not able to use this Password. If i choose mdf file from my system location and then given my server username and Password.It throws the error for - cannot start your…
Gokul Kumar
  • 389
  • 6
  • 16
0
votes
1 answer

IIf function inside Access query

I have a query and I would like to use an IIf function as part of the criteria. Here is the full SQL: SELECT Hits.HitID, Hits.ListingID, Hits.HitCount, Hits.HitDate, Hits.HitTypeID, Hits.IsDeleted FROM Hits WHERE…
Sesame
  • 3,370
  • 18
  • 50
  • 75
0
votes
0 answers

ojSelect after refresh shows blank instead of the first element

After refreshing the select list using: $(#selectId).ojSelect('refresh'); , empty element (blank) is displayed on the UI instead of the first element. Only after clicking the dropdown, the elements are shown. I need the first element to be selected…
Shashank Shekhar
  • 351
  • 3
  • 11
0
votes
1 answer

Why are certain database records being excluded from the results of this SQL query?

I have this SQL query that I use as part of a Visual C++ application that works with a Microsoft Access Database: strQuery = _T("SELECT [Public Talk Titles].*, ") _T("[Public Talk Categories].Description AS [Category Description] ") …
Andrew Truckle
  • 17,769
  • 16
  • 66
  • 164
0
votes
1 answer

Cannot read Excel files in SSIS 2008

I'm stuck trying to get SSIS 2008 to read an Excel file. Yesterday, I migrated our SSIS project from 2005 to 2008, and though the upgrade said it worked, I cannot get it to read an Excel file. I read online that I needed to upgrade the JET drivers…
Eric
  • 1
  • 1
  • 2
0
votes
1 answer

Error 80004005: how to troubleshoot this?

The Microsoft Jet database engine cannot open the file '\100.104.24.12\att2008\att2000.mdb'. It is already opened exclusively by another user, or you need permission to view its data. /functions.asp, line 36
Arvin Paul Lauzon
  • 1
1 2 3
…
38 39