Questions tagged [access-database-engine]
13 questions
1
vote
0 answers
Difference between File identifier and File name in File information list of MS Access database engine updates
I was going through July 5, 2022, update for Office 2016 (KB5002226) and I found that the file identifier and file name are different in the case of Acacedao.dll under the file information section.
Can I please know the difference between these…
Fatima A.
- 41
- 13
1
vote
1 answer
Error inserting in Microsoft Access 2002-2003 "long Text" field SQL Server 2019 linked Server Microsoft Access Database Engine 2010 x64
I am attempting to migrate a number of stored procedures, which insert to Microsoft Access 2002-2003 format database files, as linked servers.
The process is currently working fine on the following configuration
Windows Server 2008 R2 Standard
SQL…
Matt
- 23
- 4
1
vote
1 answer
How to connect my DataFactory instance to an Access Database?
So I'm setting up a dataflow to pull data from an Access DB and into my Datafactory and then pushing to the lake/datawarehouses.
I've set up an integration runtime on the VM that has the file on it. I'm using my own credentials for the moment to try…
Benjamin Bingham
- 87
- 7
0
votes
0 answers
Can I install System.Data.OleDb globally?
Whenever I open a new project in Visual Studio 2022, I have to install NuGet Package System.Data.OleDb for this specific project. However, on another machine that hasn't been configured by myself, I didn't have to install this NuGet package at…
a0poster
- 65
- 6
0
votes
0 answers
My access forms are now blank. They have been working properly for a long time and suddenly all became blank. Data still in tables. Update issue?
I have a control board with multiple editing forms, some of which have been working properly for years. They worked properly afternoon on 12/31 and morning of 1/3, all are now blank. I wonder if this is a Microsoft access update issue? Any help…
JessB
- 1
0
votes
0 answers
How to use .accdb (microsoft access database) with flutter
I have a .accdb file and i need to open and use that with Flutter&Dart like sqflite database. is there an any use this database file in Flutter
Yusuf Ersoy
- 75
- 1
- 1
- 8
0
votes
0 answers
DataFactory+Integration Runtime with Access Database not working
I've spent hours on trying to have Azure Data Factory read the onprem Access Database. I've also made the file read/writeable by everyone, I guess that should include "NT Service\DIAHostService". I wasn't able to find anything in integrationruntime…
Mara
- 371
- 5
- 16
0
votes
0 answers
Retrieving the COM class factory for component with CLSID error: 80040154 Class not registered Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG
am running wpf application on 64bit cpu machine, with .net 4.6.1, 64bit AccessDatabaseEngine 2010.
the configurations are:
Build > configuration manager > active solution platform: any cpu
project settings > Build > platform: any cpu, platform…
iris
- 1
0
votes
1 answer
Getting "7302 - Cannot Create an instance of OLE DB" Error after ACE/ODBC Driver update
We're running SQL Server 2014 with all the latest service packs. Our users heavily rely on OPENROWSET for importing XLSX, CSV and TXT files. Example:
SELECT * FROM OPENROWSET ('MSDASQL','DRIVER={MICROSOFT access TEXT DRIVER (*.TXT, *.CSV)};',…
Depth of Field
- 307
- 2
- 16
0
votes
1 answer
Syntax error (missing operator) in query expression c#
Can some one please help me to resolve the issue ?
I am getting the syntax error while running this code.
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:\CADFileLogger.accdb");
string cmdText = "INSERT INTO…
0
votes
1 answer
How to specify "read-only" for Datafactory reading from an Access DB
I'm trying to pull data out of a Microsoft Access Database. The access database seems to be used by others, and isn't owned by me/my team. I'm purely taking data out, so the user I'm setting up shouldn't need write access, but I'm not sure how to…
Benjamin Bingham
- 87
- 7
0
votes
0 answers
visual basic debit credit entry
1-Hi Sir, I have Table of General in Access Database when I make the entry like Sale and purchases payment Receipt How I bound two column (Debit and Credit) must equal than save the entry I connected database file in Visual Basic 2010.
2- I have…
Imtiaz
- 1
0
votes
0 answers
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER converting XLS to TXT
I started a new job with a brand new laptop and vanilla environment.
I have installed Visual Studio and I'm trying to convert a XLS file to TXT. This is my Control Flow:
And this is my Data Flow:
When I run the package I incur in the notorious…
Francesco Mantovani
- 10,216
- 13
- 73
- 113