943,096 Members | Top Members by Rank

Ad:
Apr 23rd, 2009
0

MyProject.exe wtih ADO Data Control

Expand Post »
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.
Reputation Points: 15
Solved Threads: 4
Junior Poster in Training
arvin2006 is offline Offline
69 posts
since Sep 2006
Apr 24th, 2009
0

Re: MyProject.exe wtih ADO Data Control

Click to Expand / Collapse  Quote originally posted by arvin2006 ...
good day everyone! how can i distribute the exe application w/o using package and deployment wizard?
You can't.

Click to Expand / Collapse  Quote originally posted by arvin2006 ...
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.

Click to Expand / Collapse  Quote originally posted by arvin2006 ...
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
Reputation Points: 156
Solved Threads: 296
Posting Virtuoso
vb5prgrmr is offline Offline
1,670 posts
since Mar 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Get Next record from table with VBA in MS Access 2003
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: How to load a webpage in a folder to a form?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC