Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-12-2016, 07:01 AM   #1
humpydumpy
Newly Registered User
 
Join Date: Jul 2016
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
humpydumpy is on a distinguished road
Connect programmatically a file dsn

hi all, I have mysql which I would like to share over WLAN. How can I make use of file dsn to connect programmatically to mysql database?

I have a file dsn that points to 192.168.x.x
The file dsn can just be loaded over front end and automatically connects to mysql database
The front end will destroy all the links upon closing the app.
Basically I can choose any file dsn should IP address change.

How can I achieve these?

Any help would be highly appreciated.
Thansk in advance.

humpydumpy is offline   Reply With Quote
Reply

Tags
file dsn , mysql , odbc , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to: Connect XLSM file to an XLSX file Bilbo_Baggins_Esq Excel 8 10-04-2013 09:53 AM
Connect to text file KenHigg Modules & VBA 2 05-15-2012 08:57 AM
How to programmatically run a batch file accesser2003 General 1 06-06-2008 03:19 AM
Access properties of file programmatically systemx Modules & VBA 0 02-12-2007 11:27 PM
Connect to a Text file (.txt) KeithG Queries 9 01-09-2007 02:02 PM




All times are GMT -8. The time now is 11:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World