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
0
votes
3 answers

reading multi valued columns from access into c#

I would like to use multivalued in access to make it easier for the user. But when reading it into c# using oledb I get the first value followed by garbage using columnname.value gets me multiple rows of the exact same data and only that column is…
AngelicCore
  • 1,383
  • 3
  • 21
  • 36
0
votes
1 answer

How to delete a row from DB (*.mdb) in c#

I have an access DB (.mdb) named: Programs, with one table named: Data. By using the DataGridView I present the data from the table Data. I want to delete a row from the DataGridView and from the DB during runtime. Does anyone know how to do that…
menachem
  • 215
  • 3
  • 8
  • 11
0
votes
4 answers

Scaleable MS Access ASP.NET app

I am constrained by the following, no way around it: Read-Only Data: Microsoft Access JET 4.0 OLDB ASP.NET 2.0 Shared Host, very little control. OR Mapper - LLBL Gen Pro The app is a read-only tool that reads a lot of Microsoft Access Databases in…
Ian Vink
  • 60,720
  • 99
  • 311
  • 535
0
votes
2 answers

NHibernate 2 + NHibernate.JetDriver + MS Access: how to access 'attachment' field of table

This is my first question on StackOverflow! I am using NHibernate 2 in my vb.net project I also use NHibernate.JetDriver to access a MS Access database I have a table named tblPeople and it has a field named 'PersonImage' witch it is of the…
Angelos
  • 11
  • 2
0
votes
2 answers

OLEDB CASE WHEN in SELECT Query

How can use case when statement with oledb to excel file ? Like select prodid, case prodid when 1 then 'fine' when 2 then 'good' end
VENKAT
  • 9
  • 1
  • 4
0
votes
1 answer

CakePHP and connecting to MS Access db using Unixodbc

I'm trying to use an Acces (MDB) database from a CakePHP app. On a Windows machine this works fine. On a Linux machine using Unixodbc this doesn't work at all. The error is as follows: Warning (2): odbc_connect() [function.odbc-connect]: SQL error:…
Bram
  • 75
  • 7
0
votes
1 answer

Select all checkboxes is not working properly

Here is my code: when i am trying to click my selectbox all its child selectboxes needs to selectable and when i uncheck the select box all its child selectboxes needs to Unselectable.i tried in following way..but didnt get exact output.can any one…
hema chandra
  • 81
  • 2
  • 10
0
votes
0 answers

Handling excel times imported from excel using Microsoft.ACE.OLEDB C#

I am importing an excel file using C# and JetOLEDb (Microsoft.ACE.OLEDB for excel 2010 and beyond), and I am using the following code: var fileName = @"C:\myexcel.xlsx"; var connectionString =…
Hassan Mokdad
  • 5,442
  • 16
  • 52
  • 86
0
votes
1 answer

SSIS import from Access 2007 fails

ERROR MESSAGE: Test connection failed because of an error in initializing provider. Unrecognized database format '\nrpi.local\commonData.accdb' I set up my database and SSIS and everything was working great. However my database was growing and when…
Holmes IV
  • 1,681
  • 2
  • 22
  • 40
0
votes
1 answer

What Jet provider is installed with MS Office 2003?

I am having problems with an app that uses the Access Database Engine 2010 on machines where Office 2003 is installed. I am getting a "not a valid password" when trying to programmatically access an ACCDB file. What could be the problem? I am…
CJ7
  • 20,640
  • 59
  • 173
  • 305
0
votes
1 answer

Cannot connect to excel from c#

I want to connect to a .xlsx file from my ASP.NET application. Here is my connection string: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Data…
Shuaib
  • 697
  • 2
  • 11
  • 43
0
votes
2 answers

Does Access 2013 still have an ACE database or equivalent?

Does Access 2013 require the use of a separate database (such as SQL Server), or does it include the ACE database or an equivalent, that is bundled in the file?
Michael T
  • 1,491
  • 5
  • 28
  • 39
0
votes
2 answers

Insert rows into Access db from C# using Microsoft.Jet.OLEDB.4.0, autonumber column is set to zero

I'm using C# and Microsoft.Jet.OLEDB.4.0 provider to insert rows into an Access mdb. Yes, I know Access sucks. It's a huge legacy app, and everything else works OK. The table has an autonumber column. I insert the rows, but the autonumber column…
MindModel
  • 752
  • 1
  • 7
  • 21
0
votes
2 answers

Downloading MDB (Access) file from IIS

This question might be better asked over on ServerFault, but since this is related to a programming project, I'll ask here. Simply put, how do I configure IIS to let me download an Access (.MDB) file the same way it lets me download .HTML, .EXE,…
AndrewBurton
  • 297
  • 6
  • 16
0
votes
1 answer

JET and ODBC driver missing, can not get data from MDBs

These are MY symptoms: (XP Pro, 32bit) -Programs that access .mdb databases (aside from Access 2007 itself) can not get any data. -Using the Data Sources in Visual Studio 2008 to connect to an MDB shows tables, but you can not query. you receive…
Andrew Arace
  • 437
  • 4
  • 11
1 2 3
…
8
9