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
36
votes
11 answers

MS Access (MDB) concurrency

For a small project I need to utilize a simple database with very light requirements: few tables, no more than few thousands of records in total, 2 or 3 users. I am working in .NET environment. As a database server (even those Express editions)…
petr k.
  • 7,830
  • 6
  • 39
  • 52
28
votes
10 answers

How to extract the schema of an Access (.mdb) database?

I am trying to extract the schema of an .mdb database, so that I can recreate the database elsewhere. How can I pull off something like this?
AngryHacker
  • 54,471
  • 90
  • 289
  • 523
15
votes
8 answers

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 wired to be limited to fewer than some power of 2 of 4KB data pages). But what does this mean in practical terms? To help me measure…
onedaywhen
  • 50,748
  • 12
  • 91
  • 132
13
votes
4 answers

Microsoft Jet wildcards: asterisk or percentage sign?

What is the proper multi-character wildcard in the LIKE operator in Microsoft Jet and what setting affects it (if any)? I am supporting an old ASP application which runs on Microsoft Jet (on an Access database) and it uses the % symbol in the LIKE…
Jan Zich
  • 13,955
  • 17
  • 58
  • 72
10
votes
5 answers

Microsoft ACE OLEDB provider throws could not find installable ISAM exception

I'm trying to read Excel spreadsheets with a 64bit Process. Therefore I use the 64 bit Version of Micorosft Access Database Engine 2010. The following code var cs = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=C:\test.xls;" …
Michael Stoll
  • 1,302
  • 3
  • 13
  • 32
8
votes
1 answer

Reading Microsoft Access files in Java

How to read (and write) MS Access files (.mdb) in Java? Is there any open-source jdbc driver for MS Access?
user68109
  • 2,366
  • 4
  • 20
  • 20
7
votes
6 answers

sql sum data from multiple tables

I have 2 tables AP and INV where both have the columns [PROJECT] and [Value]. I want a query to return something like this : PROJECT | SUM_AP | SUM_INV I came up with the code below but it's returning the wrong results ( sum is wrong ). SELECT…
Iulian
  • 1,180
  • 5
  • 21
  • 47
6
votes
7 answers

Pros and cons of the Access database engine. Life after SQLite

I asked a question a while ago about which local DB was right for my situation. I needed to access the DB from both .NET code and VB6. The overwhelming response was SQLite. However, I decided to pass on SQLite, because the only OLE DB provider…
AngryHacker
  • 54,471
  • 90
  • 289
  • 523
6
votes
3 answers

SQL Server Import and Export Wizard Error

I'm trying to import an 82k+ row table from an access db to SQL Server 2008. Using the SQL Server Import and Export Wizard, I get an error at about 78k records entered. Here's the error: Error 0xc0208265: Data Flow Task 1: Failed to retrieve long…
Paul
  • 1,560
  • 4
  • 18
  • 40
6
votes
2 answers

Excel with ACE Timeout in .NET using Data Adapter Update

I am experiencing a timeout issue writing data from a dataset into an excel spreadsheet. Here is my connection string currently:
Bob Feeser
  • 69
  • 5
5
votes
3 answers

Reading MS Access mdb files in Delphi (for free)?

I'm looking for a Delphi component / library to open and read from an mdb (MS Access) database. I will not be writing to the db or displaying the data; just need to read the db using whatever sql Access supports. This is for a personal side-project…
Marek Jedliński
  • 6,528
  • 9
  • 44
  • 55
5
votes
4 answers

C# Issue: What is the simplest way for me to load a .MDB file, make changes to it, and save the changes back to the original file?

My project that I am working on is almost finished. I am loading a .MDB file, displaying the contents on a DataGrid and attempting to get those changes on the DataGrid and save them back into the .MDB file. I am also going to create a function that…
OneShot
  • 581
  • 7
  • 19
  • 31
5
votes
3 answers

Nullable bool fields in MS Access linked tables

Looks like I'm not the only one out there with this issue, but there doesn't seem to be an anwwer to this problem. I'm working in Access 2010, using a linked table to an SQL Server 2005 database (through an SQL Server ODBC pipe). In that table, one…
David Catriel
  • 355
  • 7
  • 14
5
votes
4 answers

Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)

DECLARE @PATH NVARCHAR(1000) = N'\\MY-SERVER\C$\Folder\\' DECLARE @TABLE NVARCHAR(50) = SUBSTRING(@FILENAME,0,CHARINDEX('.',@FILENAME)) DECLARE @SQL NVARCHAR(4000) = N'IF OBJECT_ID(''dbo.' + @TABLE + ''' , ''U'') IS NOT NULL DROP TABLE…
ASindleMouat
  • 547
  • 15
  • 23
5
votes
1 answer

MS Access: Why is ADODB.Recordset.BatchUpdate so much slower than Application.ImportXML?

I'm trying to run the code below to insert a whole lot of records (from a file with a weird file format) into my Access 2003 database from VBA. After many, many experiments, this code is the fastest I've been able to come up with: it does 10000…
apenwarr
  • 10,352
  • 5
  • 44
  • 58
1
2 3
…
8 9