[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sending Access Database with ODBC Connection

Posted on 2012-08-13
3
Medium Priority
?
236 Views
Last Modified: 2012-08-16
Hi

I need to send someone an Access database with a built in ODBC connection to
my onlibe SQL database. Normally the ODBC connection would be set up manually.
Can I just send the file that results from the ODBC set up in my Documents folder?
What is the best way to do this?

Thanks
0
Comment
Question by:Murray Brown
  • 2
3 Comments
 
LVL 52

Accepted Solution

by:
Gustav Brock earned 2000 total points
ID: 38286834
It should work as is, because the connection string is stored with each linked table, and - of course - if the user is able to see your server by its IP-address or domain name.

The only problem is if the other user wish to relink - then the ODBC info must be at hand.
However, you can create a File DSN and send that to the user.

/gustav
0
 

Author Closing Comment

by:Murray Brown
ID: 38299558
Thanks for the help
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 38299751
You are welcome!

/gustav
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

831 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