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
-1
votes
1 answer

How to creata a 2-column combination into a primary key in OLEDB with VB.NET

So I did an update in the "RPD" table and the database does not have a primary key then my solution must create a primary key in the "PNM" column but I can only update only 1 row so the solution is whether it can be by combining the "PNM" column…
roy
  • 693
  • 2
  • 11
-1
votes
1 answer

How to initiate ojet menu from javascript

We are using below function in java script to trigger oj-dialog and its working fine. else if(operation === "fmethod"){ var popup = document.getElementById("fPopUp"); if (!popup.isOpen()) { …
jon
  • 213
  • 1
  • 5
  • 18
-1
votes
2 answers

filter from a table with WHERE clause not constant

In TableA clmn1 are accounts, clmn2 can take 3 value : txt1, txt2 or txt3. For each account you can have more than one value in clmn2. I need to filter accounts to take only txt1 or txt2, where txt1 is preferred over txt2 if there are both. Txt3 is…
Giovanni
  • 61
  • 6
-1
votes
1 answer

Completely group by month in query?

I am trying to write a SQL query in Access and it is driving me crazy. Table 1 has my date column (which will only have either only the 1st or the 15th of a month, in format mm/dd/yyyy). I'm also using the ID number here for each field to get the…
buckeye2114
  • 1
  • 1
-1
votes
2 answers

Need to solve this Error

Using Oledb to connect to an MS Access DB. I get the following error when the Open Function of the OleDbConnection class is called "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."
Smitha
  • 1
-1
votes
1 answer

Vb.net navigation

I'm, trying to navigate through my records but when I press the buttons, nothing happens. I'm using Jet 4.0 and an Access DB. I'm not sure what I'm doing wrong but if anyone can help me in the right direction, it would be appreciated. Code: Private…
Ian Probets
  • 123
  • 1
  • 9
-1
votes
3 answers

Can I make sql server express obey jet sql rules

I have converted a jet database to a sql server 2005 express database. The front end app contains a lot of inline sql that was written to query the jet database and this is now not working. The jet sql contains terms like True, False. String…
jjb
  • 1,340
  • 1
  • 13
  • 21
-1
votes
5 answers

Delphi: Is Ms Jet 4.0 still a good choice to develop Desktop Database App?

If I stick with Ms Jet 4.0 (Ms Access 2000-2002) to develop my desktop database program, do you think my app will become obsolete pretty fast? That is from using old db engine that will not be available in the latest windows OS like Windows 7? Or Ms…
AFF
  • 43
  • 1
  • 3
-1
votes
1 answer

Update with subselect and where

The following code works fine in T-SQL, but not in JET SQL, in Access: UPDATE Superliste_Temp SET [Plan-TGrp-Spanne_Stfl1] = (SELECT [Plan-TGrp-Spanne_Stfl1] FROM Superliste_Temp INNER JOIN dbo_Common_preferences ON Superliste_Temp.Teil =…
Vegeta_77
  • 464
  • 1
  • 5
  • 20
-1
votes
1 answer

Delete function first or last record

My main menu is where all records are displayed. The user can navigate between records by a list table which has all the records. When i use the this code to delete a displayed record, allways the first record gets…
Kamil Lazarowicz
  • 3
  • 4
-1
votes
3 answers

Using TOP in a simple SQL string (VB6)

I'm sure there is a really simple solution for this matter, but I have tried all I know without success. I'm trying to modify this fully Working SQL string to yield only the Top 25 results, not all results. Spaces corrected on this post. (I have…
Ashton
  • 329
  • 1
  • 2
  • 12
-1
votes
1 answer

Syntax Error in SQL statement (2)

I am trying to run this SQL statement in a VBA macro but for some reason it won't run due to a syntax error that I cannot seem to pinpoint. I am rather new to VBA so any help in pinpointing this error would be greatly appreciated. Dim dte As…
William
  • 9
  • 3
-1
votes
1 answer

Updating Image on database MSAccess Database Vb.net?

I want to update images in the database but when i press the button it won't update , I don't have any errors on my code. I added some code in "com.executequery" block to try if i get errors, and i get messagebox result "Error" Private Sub…
MichaelXX
  • 29
  • 2
  • 12
-1
votes
1 answer

Bug in Jet/Sql?

I'm using Jet in PHP. Querying a text field is easy, but my primary key is an integer, and I can't get the correct string. I've tried the fallowing: SELECT * FROM Table1 WHERE 'FullName' = 'ABNER AVERY' Failed! SELECT * FROM Table1 WHERE FullName =…
Lynn
  • 73
  • 1
  • 10
-1
votes
2 answers

Access file not opening.Error Messag you and another user are attempting to change the same data at same time

Access file not opening. Error Message: The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at same time. It is not repairing / compacting through database Jet Engine.
Abrar Ahmad
  • 145
  • 2
  • 7
1 2 3
…
38
39