Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access

Posted on 2011-03-07
14
Medium Priority
?
215 Views
Last Modified: 2012-05-11
How do I link to data base using VBA Code.
0
Comment
Question by:PasqualeMarcantonio
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
14 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 35059939
Here is the De-Facto standard:

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm

You will need this also (referenced in the KB):

Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

mx
0
 

Author Comment

by:PasqualeMarcantonio
ID: 35060013
I plan to open a form, test for data in a table, if the table is not found then link to the data base using VBA Code.
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 1000 total points
ID: 35060023
Example from Access help:
DoCmd.TransferDatabase acLink, "ODBC Database", _
    "ODBC;DSN=DataSource1;UID=User2;PWD=www;LANGUAGE=us_english;" _
    & "DATABASE=pubs", acTable, "Authors", "dboAuthors"

DoCmd.TransferDatabase acLink, "Microsoft Access", _
    "C:\My Documents\NWSales.mdb", acTable, "MyTable"
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:mstlwilliams
ID: 35060024
If you want to link to a Microsoft Access database from a standalone VB program, you can use ADODB.  The connection string will need to be specific for Access.  I'm looking for a sample and will post it when I find it.
You can also set up an ODBC connection for the MS Access database and use that in your VB for connecting.

0
 
LVL 75
ID: 35060085
There is no need to us ADODB to link to an Access MDB or ACCDB.

mx
0
 
LVL 85
ID: 35060296
<There is no need to us ADODB to link to an Access MDB or ACCDB.>

If you mean to link tables then you're right - DAO is much easier to work with if the goal is to build linked tables from within Access.

If the OP wishes to connect to an Access database from another environment (like VB or ASP) there's nothing wrong with using ADO. In many cases it's preferable to build a connection to the Database using ADO and then work with that connection, depending on what you want to accomplish.
0
 
LVL 75
ID: 35871357
Has this question been resolved?  Can we close the question ?

thx.mx
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36175847
I've requested that this question be deleted for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 85
ID: 36175848
The author asked how to link tables with VBA. Both of these are correct, valid solutions:

http:#a35059939
http:#a35060023

Suggest you split the points between them
0
 
LVL 75
ID: 36176996
I concur with LSM ...

mx
0
 

Expert Comment

by:South Mod
ID: 36230702
All,
 
Following an 'Objection' by LSMConsulting (at http://www.experts-exchange.com/Q_27193677.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
SouthMod
Community Support Moderator
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question