Top "Jet" questions

Jet is the SQL database engine used by Microsoft Windows.

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit …

c# .net oledb 32bit-64bit jet
Autonumber value of last inserted row - MS Access / VBA

I have a JET table with an auto-number as the primary key, and I would like to know how I …

ms-access vba jet
Maximum number of rows in an MS Access database engine table?

We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally …

ms-access jet ms-jet-ace
How to get id of newly inserted record using Excel VBA?

Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't …

sql excel ms-access vba jet
Multiple LEFT JOIN in Access

I have the following query, which works for MySQL: DELETE `test1`, `test2`, `test3`, `test4` FROM `test1` LEFT JOIN `test2` ON …

sql ms-access sql-delete jet
Reading Comma Delimited Text File to C# DataTable, columns get truncated to 255 characters

We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a …

c# .net csv oledb jet
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I am having a problem with my application. When it is run, the error displays The 'Microsoft.Jet.OLEDB.4.0' …

.net vb.net jet
Does Microsoft Jet DB work with Entity Framework?

In this forum here , someone mentions that Entity Framework does not work with Access (Jet DB - .mdb). However it …

entity-framework ms-access jet jet-ef-provider
Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed

I have created an Excel Macro in which I have used Microsoft.Jet.OLEDB.4.0 to fire query on Excel work …

vba excel oledb jet
How Can I Remove Access Db's temporary ldb file

I have an ASP.NET Project. I am connecting to the DB and then closing and disposing of the connection …

c# asp.net ms-access ado.net jet