Microsoft Access Expert For Help Connecting Excel To Access

Posted by - Adam S. at Oct 13, 2021
Maryland, United States

Toogit Instant Connect Enabled
BudgetTypeStatusValid Through
$38.75HOURLYOpenNov 3, 2021

Job Description

I need a Microsoft Access expert to consult with me on the following problem I am experiencing connecting Excel To an Access database using VBA.

Ideally, the candidate would remote desktop into my machine and get the setup correct.

In addition, since this is going to be a commercial product, we need advice on how to make sure that Excel can use Access seamlessly on our users' computers without running into these type of setup problems.

Here is the issue:

I am running the following software:

Windows 7 (64 bit)
Excel 2013 (32 bit)
Access 2016 (32 bit)

When I use the following VBA code to connect Excel 2013 to my Access 2016 database, Excel immediately crashes:

---- begin ----
Dim objConn As ADODB.Connection
Dim strDBConnection As String

strDBConnection = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Me\\Documents\\MyAccessDB.accdb;Pers ist Security Info=False;'

Set objConn = CreateObject('ADODB.Connection')
objConn.Open strDBConnection
---- end ----

I then tried using LATE binding and unchecking the reference to 'Microsoft ActiveX Data Objects 6.1 Library' in Excel 2013 and ran this code:

---- begin ----
Dim objConn As Object
Dim strDBConnection As String

strDBConnection = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Me\\Documents\\MyAccessDB.accdb;Pers ist Security Info=False;'

Set objConn = CreateObject('ADODB.Connection')
objConn.Open strDBConnection
---- end ----

In this case Excel does not crash but reports the following error:

Method 'Open' of object '_Connection' failed

I read some message board posts that recommended installing:

Microsoft Access Database Engine 2016 Redistributable
https://www.microsoft.com/en-us/down....aspx?id=54920

However, this did not solve the problem.

I even tried using just about every connection string for Access from ConnectionStrings.com but none of them work.

From what I've read in the message boards (but didn't understand completely) the problem may have something to do with the fact that my Windows 7 is 64 bit and the Excel and Acess I am using are 32 bit.

My BIG concern is that I am developing a commercial Excel spreadsheet and now I'm wondering what problems my users will experience with the software depending on their version of Windows, Microsoft Office, and whether both (or one) are 32 or 64 bit.

Skills & Expertise Required

Excel VBA Microsoft Access Administration Microsoft Access Programming Microsoft Excel 

Offer to work on this project closes in 11 days!

Try more jobs by Adam S.

Structural Drawings for 3 story masonry building - Hourly
Devops-Docker - Fixed
Need an Urgent Male Voice Over for less than 30sec video (Male, American) - Hourly
Freelance Writers Needed for Various Projects - Fixed
Devops for Deployment Automation Apache/AWS/Bitbucket - Fixed
Internet security expert needed to help me catch a hacker! - Hourly
Full Time Assistant For a Real Estate Investor - Hourly
Start Up Marketing Consultant - Fixed
3d building models for game - Hourly
Need an Urgent Male Voice Over for less than 30sec video (Male, American) - Hourly
Amazing Team Is Looking For More Hard-Working Assistants! - Hourly
MATLAB Coding - Hourly

Similar Projects

mirocsoft excell wizard

I need for you to take raw data that I have in excel document and turn in
into a pivot table

I will share a video link with shortlisted candidates full explanation.
Only apply if yo...read more
Hourly, $21.70

Data analysis and visualization for...

A remote contributor to help us with data analysis for a training program including Level-1 and 2 (pre/post knowledge surveys, and program evaluations). Currently using Excel with web-based survey too...read more
Hourly, $21.70

Utility Electricity and Natural Gas...

I would like help putting together a spreadsheet of where the utilities below have sold electricity and natural gas for the past 12 months (broken out by price per month). I would need to know the pri...read more
Hourly, $21.70

Adam hiring Excel VBA, Microsoft Access Administration, Microsoft Access Programming, Microsoft Excel experts from & nearby:

  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antarctica
  • Antiguaand Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosniaand Herzegovina
  • Botswana
  • Bouvet Island
  • Brazil
  • British Indian Ocean Territory
  • Brunei
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China
  • Christmas Island
  • Cocos Islands
  • Colombia
  • Comoros
  • Republic of the Congo
  • Democratic Republicof the Congo
  • Cook Islands
  • Costa Rica
  • Ivory Coast
  • Croatia
  • Cuba
  • Cyprus
  • Czech Republic
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • EastTimor
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • External Territories of Australia
  • Falkland Islands
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • French Southern Territories
  • Gabon
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guernseyand Alderney
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Heard Islandand McDonald Islands
  • Honduras
  • HongKong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jersey
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • North Korea
  • South Korea
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macao
  • Macedonia
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Man(Isleof)
  • Marshall Islands
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar
  • Namibia
  • Nauru
  • Nepal
  • Netherlands Antilles
  • Netherlands
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norfolk Island
  • Northern Mariana Islands
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Territory
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Pitcairn
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Reunion
  • Romania
  • Russia
  • Rwanda
  • Saint Helena
  • Saint Kittsand Nevis
  • Saint Lucia
  • Saint Pierreand Miquelon
  • Saint Vincentandthe Grenadines
  • Samoa
  • San Marino
  • Sao Tomeand Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • SierraLeone
  • Singapore
  • Slovakia
  • Slovenia
  • Smaller Territories of the UK
  • Solomon Islands
  • Somalia
  • South Africa
  • South Georgia and the South Sandwich Islands
  • South Sudan
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Svalbardand Jan Mayen
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • Togo
  • Tokelau
  • Tonga
  • Trinidadand Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turksand Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • United States Minor Outlying Islands
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Vatican
  • Venezuela
  • Vietnam
  • British Virgin Islands
  • U.S.Virgin Islands
  • Wallis and Futuna
  • Western Sahara
  • Yemen
  • Yugoslavia
  • Zambia
  • Zimbabwe
  • Aland Islands
  • Saint Barthélemy
  • Bonaire, Saint Eustatiusand Saba
  • Curaçao
  • Guernsey
  • Isleof Man
  • Jersey
  • Montenegro
  • Saint Martin
  • Sint Maarten
  • East Timor
  • Kosovo