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

How to obtain locked records in table

I have an unsplitted database at terminal server with about 15 concurrent users. Some user actions run vba code with both SQL and DAO data manipulations and sometime cause record locked errors. For debug purpose i want to monitor locked records in…
4dmonster
  • 3,012
  • 1
  • 14
  • 24
0
votes
0 answers

Access to SQL migration. Error GROUP-BY expression must contain at least one column that is not an outer reference

I have migrated an 2010 Access DB tables to SQL Server 2012 and linked them to the Access FE. I have pass through queries with return record set to no. I use the final result table which are linked in the FE of access for reporting purpose. Each…
WiredTheories
  • 231
  • 7
  • 18
0
votes
1 answer

Operation must use an updatable query Microsoft Access 2010 running on SQL Server 2012

I have an Access 2010 FE , with linked tables on SQL Server 2012. I have several queries which are passed through used for the generation of reports. After migration and recreation of the queries. When I run the reports it throws up the above…
WiredTheories
  • 231
  • 7
  • 18
0
votes
1 answer

Error #Name? in access form with DLookup

I have the error #Name? in a form in Access 2013 in a textbox that have as origin a DlookUp function. Specifically I need to do the same thing that is on this topic: automatically update the field Costo Unitario field based on the selection of the…
Ponzaro
  • 139
  • 2
  • 5
  • 16
0
votes
1 answer

Error accessing certain Excel sheets with Jet

I am using ASP.NET to open an Excel 2003 document hosted on the server. The excel spreadsheet, produced by a system outside of my control, has 5 named worksheets. I access the data in each sheet as follows (line breaks added for…
Mayo
  • 10,544
  • 6
  • 45
  • 90
0
votes
2 answers

MS Access VBA: Using workspace.OpenDatabase to connect to an unavailable SQL server via an ODBC connection - elegant recovery?

In an application that uses a MS Access form as a front-end to some SQL databases, I use DBEngine.CreateWorkspace to get a workspace, then workspace.OpenDatabase to connect to my remote SQL server via a defined ODBC System DSN. This all works quite…
LMF
  • 3
  • 1
  • 2
0
votes
2 answers

Jet(Access) DB and Expression based columns?

I occasionally work on an old project that uses classic asp as a front end and an access database as a backend. I'd like to create a new column in one of the tables that contains logic to calculate its value from the other columns in the row. I know…
FlySwat
  • 172,459
  • 74
  • 246
  • 311
0
votes
1 answer

using ResultSet.Previous method not working in Java using .mdb file OBDC

I'm currently having an issue with my open result set not working how I believe it should. The only function that is currently working is the next() method, nothing else will work. If the project is placed into a debug mode you can follow through…
user311100
  • 1
  • 1
0
votes
2 answers

Add columns to an Access (Jet) table from .NET

Our app (already deployed) is using an Access/Jet database. The upcoming version of our software requires some additional columns in one of the tables. I need to first check if these columns exist, and then add them if they don't. Can someone…
Jon B
  • 51,025
  • 31
  • 133
  • 161
0
votes
1 answer

Data mismatch error in multiple UNION SQL Jet query

I have the following query in Jet SQL. Basically each of the subqueries A,B and D generate one column in the final table. If I run the query as is I get a 'Data type mismatch in criteria expression'. If I remove any one of A, B, D it works fine. I…
Andy Powell
  • 583
  • 1
  • 6
  • 15
0
votes
2 answers

Replacing values with an ID when importing tables in MS Access

I have imported data from a monolithic csv file into MS Access. One of my fields is notes which can be pretty much anything, or be any length. Regardless, its content is often repeated across records. So I have split each unique note into a new…
user3758291
  • 129
  • 1
  • 8
0
votes
2 answers

Oledb reading multiple excel files on server causes type error

Initially I had an issue with the data type "guesses" when dealing with the jet driver (through oledb). If a sheet had mixed types, it would bring in null/empty values. -Edit- There is an IMEX setting in the connection string as well as in the…
loctrice
  • 2,454
  • 1
  • 23
  • 34
0
votes
1 answer

Old asp application works on Vista but not on Windows 7

I have an old asp application I am trying to move from a Vista machine to a Windows 7 64 bit machine. I developed the application but am not an expert web developer. The home page is rendering properly with no errors but the data from the Access…
urbanmojo
  • 737
  • 3
  • 12
  • 21
0
votes
1 answer

What is the SQL dialect used to query CSV files through the OleDB Jet driver?

I am trying to execute a query against a CSV file using OleDbConnection, OleDbCommand and the Microsoft.Jet.OLEDB.4.0 driver but keep getting an exception saying no value given for one or more required parameters. I suspect the problem is in the SQL…
Ivan
  • 63,011
  • 101
  • 250
  • 382
0
votes
1 answer

DAO large query lockup on Win7 multicore

I have a C++ app that uses a Jet database through DAO. Large queries work well up through Vista but lockup under Win7 on a multicore machine. I have tried both jet 3.5 and 4.0. Both fail. I have tried disabling threads in calling prog (my app) -…
MighMoS
  • 1,228
  • 8
  • 18
1 2 3
…
38 39