Top "Ms-jet-ace" questions

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

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
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 …

sql join ms-jet-ace
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 …

ms-access ms-jet-ace
MS Access (MDB) concurrency

For a small project I need to utilize a simple database with very light requirements: few tables, no more than …

.net database ms-access concurrency ms-jet-ace
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.…

c# excel oledb ms-jet-ace
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 …

excel oledb ms-jet-ace
Using math functions in Sql with MS Access

I designed a query in SQL View using MS Access: select floor(num1) from t1; When I run it, I …

sql ms-access ms-access-2007 ms-jet-ace
INSERT INTO statement contains following unknown field name

I’m using Coldfusion 9,0,0,251028 on Windows 7 64-bit, with a Microsoft Access 97 database. When I run this query: <cfquery name="…

ms-access coldfusion insert ms-jet-ace
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 …

sql delphi ms-access components ms-jet-ace
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)? …

sql ms-jet-ace