How to connect vba access 2010?

Asked By Curtis Marry 50 points N/A Posted on - 12/15/2012

Hello techyv,

How to connect vba access 2010?

I would like to connect my visual basic 6 calculator system in Microsoft Access 2010 database.

I need a database that will hold all the possible data to be entered and save by the system user.

Can you give me a step by step process on how to connect it properly?

This is for my office database.

Expecting some help from you guys.

Thank you.

• Status: Open
• Question Views: 1118
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Maxwell Mark 0 points N/A #185889

How to connect vba access 2010?

Hi,

To connect to VBA in access 2010,you need to use the code below:

Dim sSQL As String

Dim rs As ADODB.Recordset

Dim cn As ADODB.Connection

Set cn = New ADODB.Connection

cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=S:MyFoldermyDB.accdb;Persist Security Info=False"

sSQL = "Select top 2 from Table1"

Set rs = New ADODB.Recordset

rs.Open sSQL, cn

ActiveWorkbook.Sheets("Control").Cells(6, 1).CopyFromRecordset rs

rs.Close

Set rs = Nothing

cn.Close

Set cn = Nothing

If there are any errors, use the following code in rs Run-time error '-2147217900 (80040e14)':  Automation error and you want to VBA for Access 2010 to SQL 2008 R2 just visit this link: 

Thanks, Max

About Maxwell Mark

Questions
5

Answers
101

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 01/26/2013
• Question Category: Visual basic