Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Excel VBA,Microsoft Access Administration,Microsoft Access Programming,Microsoft Excel freelancer for Microsoft Access Expert For Help Connecting Excel To Access job

Posted at - Oct 26, 2018

Toogit Instant Connect Enabled


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.

About the recuiterMember since Jul 12, 2017 Ashwini P.
from Maharashtra, India

Skills & Expertise Required

Excel VBA Microsoft Access Administration Microsoft Access Programming Microsoft Excel 

Candidate shortlisted and hired
Hiring open till - Oct 26, 2018

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$34.80
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


Apply on more work from home jobs posted in Network And System Administration category.


Related Jobs


Latest In Excel VBA Jobs


Latest In Microsoft Access Administration Jobs


Latest In Microsoft Access Programming Jobs


Latest In Microsoft Excel Jobs