Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access
Posted on 2011-03-07
How do I link to data base using VBA Code.
[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
4
2
- +4
14 Comments
Active today
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
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
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.
Active today
Example from Access help:
DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=DataSource1;UID=
& "DATABASE=pubs", acTable, "Authors", "dboAuthors"
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"C:\My Documents\NWSales.mdb", acTable, "MyTable"
DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=DataSource1;UID=
& "DATABASE=pubs", acTable, "Authors", "dboAuthors"
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"C:\My Documents\NWSales.mdb", acTable, "MyTable"
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.
You can also set up an ODBC connection for the MS Access database and use that in your VB for connecting.
Active today
<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.
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.
Active today
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.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Active today
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
http:#a35059939
http:#a35060023
Suggest you split the points between them
Active today
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
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
Featured Post
Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
- Databases
- AWS
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 21 hours left to enroll
635 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.