Stack Overflow
Stack Overflow

Questions tagged [ms-jet-ace]

Office Access Connectivity Engine (ACE) is a new version of the Jet database engine and is available in Microsoft Access 2007 and later.

Excerpt from Wikipedia (2014-07-25):

With version 2007 onwards, Access includes an Office-specific version of Jet, initially called the Office Access Connectivity Engine (ACE), but which is now called the Access Database Engine. This engine was fully backward-compatible with previous versions of the Jet engine, so it read and wrote (.mdb) files from earlier Access versions. It introduced a new default file format, (.accdb), that brought several improvements to Access, including complex data types such as multivalue fields, the attachment data type and history tracking in memo fields.

124 questions
4
votes
4 answers

Compatible DDL (CREATE TABLE) across different SQL databases?

I'm working on a desktop application that must support (currently) MS Access and SQL Server back ends. The application is under constant development and changes are frequently being made to the database, mostly the addition of tables and views to…
Larry Lustig
  • 46,058
  • 13
  • 95
  • 143
4
votes
1 answer

ACE OLEDB "External table is not in the expected format" with large text in Excel cell

I'm trying to read an .xls file that happens to have a very large text cell (around 8900 chars) using System.Data.OleDb and the Microsoft ACE OLEDB provider. I have no control over the content of the .xls file. I get the following exception when…
CoderBrien
  • 614
  • 1
  • 6
  • 20
3
votes
1 answer

Running exe on 32/64 work with ACE-Driver

i want to run ONE exe on a 32b / 64b OS. I use the VS-settings x86 to use the wow64 mode. The exe work with no erros. Now i want to start to support office 2010 with 32b and 64b, i decided to use the "Microsoft Access Database Engine 2010…
David
  • 425
  • 2
  • 7
3
votes
1 answer

Jet database 32 and 64 bits and alternatives

We have an application that makes use of OLEDB and the Jet engine Microsoft.Jet.OLEDB.4.0. We are converting our application to also run in 64-bit mode. However, the database engine is no longer a standard part of 64-bit Windows. But Office 2010…
Kharina Tigerfish
  • 659
  • 6
  • 11
3
votes
2 answers

32-bit and 64-bit Office on the same pc - trouble with MS access database driver

I received an error while trying to execute an MS SSIS package that contained Excel source: "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine". While trying to install MS Access Database driver 64-bit, and then MS…
user2008973
  • 315
  • 3
  • 6
  • 22
3
votes
1 answer

Delete 5 Records but RecordsAffected Property is 0

Here is a code snippet: Private Sub frmSearch_UnMarkAll() Const sqlD As String = "DELETE * FROM PickList WHERE TableName = ""CARS"" AND KeyNo IN (" & _ "SELECT RecNo FROM Cars " If frmSearch.WhereSql <> vbNullString Then CurrentDb.Execute sqlD &…
Perry Sugerman
  • 169
  • 1
  • 8
3
votes
2 answers

Creating a new database (.mdb) with ADO.NET

How can I create a empty .mdb file? I'm using ADO.NET and C#. Thanks!
Malfist
  • 29,255
  • 58
  • 174
  • 263
3
votes
2 answers

INTERSECT multiple subqueries in MS-Access (without INTERSECT keyword)

I need to intersect multiple subqueries in MS Access. Unfortunately, Access-SQL does not support the INTERSECT keyword. I understand, how we can use INNER JOIN of two tables to get the intersection we want. But how can I programmatically create a…
Coloss
  • 45
  • 5
3
votes
2 answers

ACE.OLEDB provider incorrectly reads some column names

I'm reading an excel file from a C# app using ACE.OLEDB. Everything has worked fine so far until today I noticed that one of the column names is read incorrectly. Here's what I've got in my excel file Here's what I've got in my debugger Basically…
taralex
  • 905
  • 2
  • 11
  • 28
3
votes
3 answers

SSIS Package Fails After Move to 64-bit

We've got a a series of SQL Server Integration Services packages that copy data from a few MS Access databases into a SQL Server 2008 database. There is one parent package that calls the various sub-packages, and that parent package is initiated by…
Supermercado
  • 33
  • 2
  • 4
2
votes
2 answers

How can I prevent Microsoft ACE and JET in VB6 duplicating data from the first row in Excel spreadsheet?

I'm dealing with a legacy application written in VB6 which reads in Excel spreadsheets and inserts them into a database. It works for the most part, but if the data in the spreadsheet does not start on the first row, the first data row gets…
Aradiel
  • 23
  • 4
2
votes
1 answer

Access 2010 runtime causes .NET OleDbConnection.Open() to fail with Access97 MDB file

I maintain a .NET 3.5 application (using Visual Studio 2008) that makes a call to OleDbConnection.Open() with a connection string provider of Microsoft.ACE.OLEDB.12 and an MDB file with format Access97. This application has a requirement that the…
MarkA
  • 21
  • 2
2
votes
2 answers

The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine

I have built a small WPF app that will read in XLS or XLSX files and display the contents in a datagrid. I have the XLS side of things working by using the Microsoft.Jet.OLEDB.4.0 provider. I am struggling with the XLSX side of things. I am running…
Kris
  • 81
  • 2
  • 3
  • 14
2
votes
2 answers

ACE oleDb drivers unable to handle huge excel files

Does ACE OLEDB drivers have any known issues with larger files? I am using the below code to retrieve the worksheets in a 400Mb xls file public string[] GetWorkSheets() { var connectionString = "Provider=Microsoft.ACE.OleDb.12.0; data…
Mulki
  • 5,309
  • 1
  • 28
  • 38
2
votes
1 answer

Excel upload not working on windows Server 2012

I have developed an application where the user have to upload a winzip archive file. The code then extracts an Excel file (in .xls format, 97-2003 workbook) from that archive and uploads the data within that Excel file into my SQL database table.…
IntelligentCancer
  • 81
  • 1
  • 9
1
2
3
…
8 9