Remote Network And System Administration Job In IT And Networking

Microsoft Access Expert For Help Connecting Excel To Access

Find more Network And System Administration remote jobs posted recently Worldwide

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 Ive read in the message boards (but didnt 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 Im 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.
About the recuiter
Member since Aug 30, 2017
Adam S.
from Maryland, United States

Candidate shortlisted and hiredHiring open till - Nov 3, 2021

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$34.76

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Are looking for a car expert who is familiar with the model series of the Audi brand.

Hello dear freelancers,
We need a list of Audi sports models for a sound library. It is important that different generations are involved. It is particularly interesting how the sound of the S5 (etc.) has developed over the years, which is why th...read more

Bali Villa Research (Sales and Rental Prices for Seminyak, Sanur and Canggu)

Through online reseach, provide detailed list of 3, 4 and 5 bedroom villas in Canggu, Seminyak and Sanur that are currently for rental or sale. Provide a detailed list of location, size, bedrooms, bathrooms and more.

Using sources such as A...read more

Recover Unsaved Excel file on my Macbook.

Excel crashed and I am having difficulty recovering the file. All I have is the previous version of the file the day before it crashed. I had done a lot of work since the last saved version. I can give team viewer access.

Executive Assistant to CEO Needed for Growing Brand

Were looking for a remote executive assistant to assist the owner of our company located on the East Coast.

Here are a few examples from the past month that would fall under your role:
- Booking travel for owner (hotels and flights)read more

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)