954,559 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

MyProject.exe wtih ADO Data Control

good day everyone! how can i distribute the exe application w/o using package and deployment wizard? i just made it executable. the problem is the the database path changes because i did not use the App.Path. I know how to use App.Path using ADODB, but with ADO Data Control, you can only set by means of setting the properties at design time (such as C:\Documents and Settings\Arvin\My Documents\My Files). Of course, if I distribute the exe, the specified path will no longer be the path. Or is it possible with App.Path. Any idea on how to solve this issue. Thank you for responses.

arvin2006
Junior Poster in Training
69 posts since Sep 2006
Reputation Points: 15
Solved Threads: 4
 
good day everyone! how can i distribute the exe application w/o using package and deployment wizard?

You can't.i just made it executable. the problem is the the database path changes because i did not use the App.Path. I know how to use App.Path using ADODB, but with ADO Data Control, you can only set by means of setting the properties at design time (such as C:\Documents and Settings\Arvin\My Documents\My Files).

Yes you can set the properties of the ADODC in code. Just use the name of the ADODC (ADODC1) . (dot) the same property name that is in the property window = the setting you have.Of course, if I distribute the exe, the specified path will no longer be the path. Or is it possible with App.Path. Any idea on how to solve this issue. Thank you for responses.

If the database is meant for single user then you can use the app.path method or if you want you can use the common dialog to allow the user to navigate to the database to select it.

Good Luck

vb5prgrmr
Posting Virtuoso
1,912 posts since Mar 2009
Reputation Points: 156
Solved Threads: 296
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You