Updating Legacy VBA to the 21st Century
I am starting to work with a file written in excel 97 & access 97 for forecasting, it is fairly involved and does a great job of profiling etc. However the business has undergone an upgrade and we are all now using Windows 7 & Office 2013 (x64), from what was previously XP & 2003/7
As a result the coding, written by a number of parties over the years, is now failing
Upon opening the file I encounter an Run-Time error 3706, falling over the
Set dbConn = New adodb.Connection dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & ThisWorkbook.path & "\" & mdb_name
Following my practice of Google and forums, which until now have solved any/all problems I found and installed the Microsoft Access Database Engine 2010 Redistributable but this has not solved this issue - although that might have been too easy.
I have straight swapped the code to
Set dbConn.ConnectionString = "Provider=microsoft.ace.oledb.12.0;" & _ "Data Source=" & ThisWorkbook.path & "\" & mdb_name
which changes the error to a Compile error "Can't find project or library"
I would very much not have to go down the route of virtual machines and x86 software to continue with this, but it is critical to my sanity that I get this working... and a total re-write I feel is beyond my skill and the time I have available.
I am Betty Andrews. No I dont have much idea but you can update the MS-Access to the latest version. I want to also add on that there is a brilliant opportunity for essay writers. Whoever wants to write excellent essays please do take the help of essayhelp college website. For ore information please log onto the website http://essayhelpcollege.blogspot.com
I have the same issue - can anyone resolve this?
Peter, CEO Boiler Service UK
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data0 votes0 answersRichard1 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 Hammock3 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 answerunknown4 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 Noviskie5 months ago
Excel data source as Stream instead of physical path
I have a connection string as below. connectString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;ISAM=1;TypeGuessRows=0'";0 votes0 answersJERIN ANTONY5 months ago
Connection error to SQL in Excel 2007
Hi, I have connected a Excel 2016 file to a SQL Server and it works ok. An user, who has Excel 2007 version should use the same file and he is reporting this error while refreshing the data: Run-time error '1004': Application-defined or object-defined error.0 votes0 answersJ Jesus Romero6 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 Tan6 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 answersRoel7 months ago
Excel Chart Wizard, Connecting Scatter Diagram points
I'm composing a chart from 3 columns of data, and need help to format on Excel for Mac, Office 365. All columns are %s. first is X axis: relative % 0 - 200, of Y and Z.0 votes0 answersMarty McGowan8 months ago
Could not find installable ISAM
Hi I am using excel 2010, my excel file connected to dbf file and excel file has my pivot tables based on the dbf file and once the dbf file is updated I refresh the excel file and all the charts are updated.0 votes0 answersTauqeer Khan9 months ago
- Load more posts