Access 2010: Link to DBF via VBA / ADO
I have been linking programmatically to DBF files for 15+ years in different Access versions (currently 2010) OK. The client outputs the DBF files via R:BASE . . . previously DOS version, now upgraded to a Windows version.
I can link to the "new" DBF tables "manually" via LinkedTableManager OK (dBase III) in Access. The "old" tables show DOS field names: ALL CAPS, truncated to 8 chars. The "new" tables show Windows field names: extended length, mixed case, etc.
I programmatically build the connection string the same way as always, including: tblADOX.Properties("Jet OLEDB:Link Datasource") = strPath tblADOX.Properties("Jet OLEDB:Link Provider String") = "Dbase III" and it throws off err.number = -2147467259 upon catADOX.Tables.Append tblADOX
This is obviously VBA code. I have set the references to the most recent Microsoft ActiveX Data Objects (6.1 Library) I can find, but still get the same error. I also now understand that ACE has replaced JET but a straight substitution of "ACE" for "Jet" bombs immediately (err.number = 3265) and that is all I know.
Thanks in advance!
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan2 weeks ago
How to read values in a particular column of DBF file in c#
How to read values in a particular column of DBF file in c# code0 votes1 answerp bimsara3 weeks ago
Interbase ODBC to Access with foreign characters
I have a legacy Delphi database, with an application written in Borland Pascal. It's an old system, running on a virtual XP box, since it won't run on anything newer.0 votes0 answersPete D1 month ago
User Supplied OLEDB Password
Is it possible to supply a database password that is let's say supplied when the user logs into the website. Example "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\MyName\Documents\mywebsite_assets\database\database.mdb; Jet OLEDB:Database Password=" + strPassword0 votes0 answersSteve Hammock6 months ago
Simplest way to get ADO.NET conection string for mdb database
I'm learning ADO.NET and have been stuck for DAYS trying to get a connection string for a plain, vanilla .mdb database. I've been trying potential connection strings and permutations from this site but NOTHING works; the database connection is never opened.0 votes1 answerunknown7 months ago
Passthrough query connstring from Access VBA to Azure SQL works on one PC and not on others!
Hi, We have an Azure SQL database and a local Access app that needs to interact with it. Using VBA-generated pass-through query definitions to grab data as needed, no linked tables and no permanently saved queries.0 votes0 answersMike Noviskie9 months ago
What is the Connection string for ACCESS 2007 .mdb on Windows 7 (64-bit)?
I have tried the following variations of the same statement in Powershell 5.1: $objCon.Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\MyDocuments\WWW.mdb")0 votes1 answerRamon Tan10 months ago
Problem with connecting to an Access 97 db on Linux with Debian7
I have an Acces 97 database working on a Windows 7 PC where I can get data from it by XAMPP with phppdoodbc. I want to have this database on a QNAP NAS with Linux arm5, on Debian9 with a working Apache2 and PHP7, but I cannot get it to work. I now use:0 votes0 answersRoel10 months ago
MVC C# connection to FoxPro database
I am working with an MVC application, problem is, is it possible to write to a Visual FoxPro database from an MVC application? .. If possible any help in regards with this will be highly appreciated.0 votes0 answersJason Venter12 months ago
ASP connection to .xls
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")0 votes0 answersWisdom Dekuon Mar 20, 2018
- Load more posts